Re: trunc

From: Kurt Laugesen <kul_at_post3.tele.dk>
Date: Wed, 12 May 1999 17:42:00 +0200
Message-ID: <7hc80j$ndt$1@news.inet.tele.dk>

select to_char(trunc(date_field),'HH24:MI:SS') from table1 will do what you want
(MM is the month - a mistake I've seen recently - so in May the time was allways 5 minutes past :-) )

Regards
Kurt Laugesen
kurtL_at_corebit.dk

G.H VITTAL wrote in message <373972BE.CB63D362_at_india.hp.com>...
>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 - 10:42:00 CDT