Re: Y2K bug?

From: Martin Hepworth <maxsec_at_totalise.co.uk>
Date: 2000/07/11
Message-ID: <396AC8EB.3AB8B301@totalise.co.uk>#1/1

Eric Cheng wrote:
>
> Hi fellows,
>
> I have a question for you.
> Please try to run the following command and let me know what you get.
>
> 1. select ename, SYSDATE, hiredate, (SYSDATE-hiredate)/7 WEEKS
> 2. from emp
>
> All I got are negative numbers, however are we supposed to get
> positive numbers? Is this a Y2K bug?
> IMO, the current date minus hiredate should be positive numbers.
> I am using ORACLE8i on Redhat, I haven't tried this on NT yet.
> Maybe you already ran into this one.
> Thanks!
>
> Eric Cheng

Eric
make sure the NLS_DATE_FORMAT it set correctly on the server AND the client.

Martin Received on Tue Jul 11 2000 - 00:00:00 CDT