Date Difficulties 2

[campbere]

I am trying to run the following query in Oracle but I am getting no rows, when I know they exist.

select * from table where ddate > '31-DEC-98'

ddate is listed as a date column.

Can anyone help?

 

[ATP]

This should work as Oracle usually converts the string to a date date format. If it's the wrong format then it should complain.

To make sure it's converting to a date try:
select * from table where ddate > to_date('31/12/1998','DD/MM/YYYY')

 

[MikeJones]

try...

select * from table where ddate > to_date('31-DEC-98','DD-MON-RR')

or...

select * from table where ddate > '31-DEC-1998'


HTH,

Mike.

 

[campbere]

Thanks the to_date function was the trick.