Re: How to compare a datetime field to a Date

Hi Tony,

Thank you for your answer.
I already solved this way
where to_date(dh_entrada) = to_date('18/10/2004')

Regards,
Marcello Dias
"Tony Andrews" <andrewst_at_onetel.com> wrote in message news:<1098197756.159746.311950_at_z14g2000cwz.googlegroups.com>...
> 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 - 13:31:35 CDT