Re: How to compare a datetime field to a Date

md9_at_ibest.com.br wrote:
> 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.

Select * from table where TRUNC(datettiemfield)= TO_DATE('10/18/2004','MM/DD/YYYY') Received on Tue Oct 19 2004 - 09:55:56 CDT