Re: to_date function

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

Is that true? I do not believe that. Where can I read about such.

select * from tableA where trunc(created_date) = to_date('15/12/01', 'dd/mm/yy');

regards

Nicolas Received on Wed Dec 19 2001 - 04:43:32 CST