Re: trunc

From: Mark Powell <Mark.Powell_at_eds.com>
Date: 12 May 1999 16:06:57 GMT
Message-ID: <01be9c91$8d8be860$a12c6394@J00679271.ddc.eds.com>

You specified that you want the time in your to_char. I think you just want to select trunc(sysdate) from table1 or more likely write something like trunc(date_col) = :variable OR a constant '10-May-99' so that the compare ignores the time portion of the date entry.

I hope this reply is of value to you.

G.H VITTAL <vittal_at_india.hp.com> wrote in article <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 - 11:06:57 CDT