Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to compare a datetime field to a Date
HI I would like to do something like this
Select * from table where date(datettiemfield)= TO_DATE('10/18/2004')
I want the hour to be ignored in the comparison.
Regards,
Marcello Dias
Received on Tue Oct 19 2004 - 09:46:05 CDT