Re: Newcomer's date question

From: Eugenio <eugenio.spadafora_nospam_at_compaq.com>
Date: 2000/06/16
Message-ID: <8icvno$29m$1@mailint03.im.hou.compaq.com>#1/1

hahahahhahahha

It's Friday !!!!!!!!!!!!!!!

We are in 2000 !!!!!!!!
Linda, check your DATE format settings.
Probably your server/client doesn't have the RR settings for the year.

And then you're querying

   between 01-MAY-2081 and 09-JUN-2081.
Scott employee's data are related to the previous millennium.

Your problem is...THE MILLENNIUM BUG !

Run

   alter session set nls_date_format='DD-MON-RR'; and your query will work.

Otherwise use the RR setting in the query o 4 digit years in date formatting.

WHERE hiredate between to_date('01-MAY-81 00:00:00', 'DD-MON-RR HH24:MI:SS')

                                     and to_date('09-JUN-81 23:59:59',

'DD-MON-RR HH24:MI:SS') or

WHERE hiredate between to_date('01-MAY-1981 00:00:00', 'DD-MON-YYYY HH24:MI:SS')

                                     and to_date('09-JUN-1981 23:59:59',

'DD-MON-YYYY HH24:MI:SS') FRIDAY !!!!!

--
be happy

Eugenio
remove _nospam from reply address

Opinions are mine and do not necessarily reflect those of my company

=======================================================
Eugenio wrote in message <8icul4$1s6$1_at_mailint03.im.hou.compaq.com>...


>Yes, it is !!

>

>I saw only the 9-JUN line !

>

>But for the 1-MAY line the original query should work !!!

>

>It's Friday

>

>--

>be happy

>

>Eugenio

>remove _nospam from reply address

>

>Opinions are mine and do not necessarily reflect those of my company

>

>=======================================================

>Kathinka Diehl wrote in message <8ictrh$4ktvg$1_at_fu-berlin.de>...

>>

>>Eugenio <eugenio.spadafora_nospam_at_compaq.com> schrieb:

>>>

>>>    to_date('01-MAY-81 00:00:00', 'DD-MON-YY HH24:MI:SS')

>>

>>But IIRC this is excactly the same as '01-May-81'.

>>

>>Mysterious.

>>Kathinka

>>

>>

>>

>

>

Received on Fri Jun 16 2000 - 00:00:00 CDT