Problem with date

[DKL01]

Hi,

I'm getting "not a valid month" error with following query. What could be the problem ?

select * from table1 where day = to_date('11/19/2001','DD-MON-YYYY')

day column has following values:
19-NOV-2001
18-NOV-2001
:
:


Thanks

 

[karluk]

Your to_date function is using a format that's not compatible with the '11/19/2001' value you are trying to convert. Try to_date('11/19/2001','mm/dd/yyyy') instead.