SQL COMMAND

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 - 10:29:44 CST