Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Y2K Question

Re: Y2K Question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 22 Jun 1999 23:30:08 +0200
Message-ID: <930086945.19221.0.pluto.d4ee154e@news.demon.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US