Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL COMMAND
Read the docs on the TO_DATE() function. It has a second parameter.
"Dominique PREVOT" <dominique.prevot_at_eds.com> wrote in message
news:3DFF50F8.7080407_at_eds.com...
> Hi,
> Does anyone know if there is a SQL command that convert a date-time
> value to a date value ?
>
> For instance,
>
> select * from table where (TO_DATE(CreationDate) < 2002/12/01);
>
>
> (where CreationDate is a date-time field (yyyy/mm/dd:hh:mm:ss:lll))
>
> Thanks for help,
> Dominique
>
Received on Tue Dec 17 2002 - 11:00:47 CST