Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to compare a datetime field to a Date

How to compare a datetime field to a Date

From: <md9_at_ibest.com.br>
Date: 19 Oct 2004 07:46:05 -0700
Message-ID: <75ba751c.0410190646.360bdf2d@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US