Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007
    Posts
    2

    Unanswered: TO_DATE with DY parameter in SELECT

    Hi,

    I use this string an get an ORA-01846 error:

    Code:
    SELECT TO_DATE(DO_END, 'DY') as start1 FROM TABLE1
    The DO_END is a DATE field.

    What can I do wrong with such an easy string?
    Can anyone help me?
    I use oracle about 5 years now and have used thousands of TO_DATE calls but this problem is new to me....

    Thanks in advance...

  2. #2
    Join Date
    Feb 2007
    Posts
    2
    Solved!
    I use TO_CHAR now....

    Thanks anyway

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •