trunc

Whenever we do date comparison I remember using trunc command
if i say

select to_char(trunc(date_field),'HH:MM:SS') from table1

I see only second portion is truncated. But i want to truncate the entire time portion i mean i should expect 00:00:00 as the result. How do i do this ?

regards
vittal Received on Wed May 12 1999 - 07:23:26 CDT