Re: to_date function

Jim Kennedy wrote:

>Yes, you can truncate the created_date, but that will force a full table
>scan just to get the date component as of midnight.

And what about:

SELECT *
FROM table
WHERE
to_date(to_char(date_field,'dd/mm/yyyy'),'dd/mm/yyyy')=to_date('15/12/2001','dd/mm/yyyy')

Volker Received on Tue Dec 18 2001 - 16:12:58 CST