Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Y2K Question
Hi Dogan,
The answer is no. The trunc function is overloaded and as it is operating on
a date column or variable
(which you didn't specify by the way) it will return a date value with only
the time removed.
So the comparison below is sufficient.
Hth,
Sybrand Bakker, Oracle DBA
Dogan Cibiceli wrote in message <376FE917.17248BF5_at_gwl.com>...
>Hi,
> Suppose you are writing Oracle PL/SQL program and you got two dates
>from tables. IF you compare them using trunc(date1) > trunc(date2), do
>you need to convert them to 'DD-MON-YYYY' format or compare ? Or the
>comparison above is enough to ensure Y2K compliance ?
>
>D
>
Received on Tue Jun 22 1999 - 16:30:08 CDT