day of week conflicts with Julian date

[aspiringprog]

I have dates stored in this format

Jan 1 2003 12:00:00:000AM
Hi all

I need to convert this into mm/dd/yyyy format so that I can compare with dates from another table. When I try using the
following function

TO_DATE(SUBSTR(DT,1,10),'MON DY YYYY')

I get the following error

ORA-01835: day of week conflicts with Julian date

Can you please tell me how to get rid of this error?

Thanks

 

[BJCooperIT]

1. You are only selecting 10 characters from DT - your format implies it should be 11 characters.

2. In your format, the DY stands for the abbreviated name of day (THU, FRI, etc.). That should be DD, day of month (01,02...31).

If it really is 10 characters then perhaps MON is not correct. MON is the abbreviated month name (JAN, FEB), perhaps you mean MM, numeric month (01,02...12).

It would be much easier to diagnose if you would describe your table and post data samples.

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: www.EmuProductsPlus.com

 

[aspiringprog]

Hi BJCOOPER

Yes..I realised my mistake of selecting only 10 characters in the substring...

thanks for the reply.