Re: Newcomer's date question

Just FYI

If you don't have the RR mask set in your date format, and you load the demo tables, the *current* century will be automatically used. As right now the century in the date column is already wrong, using the RR mask in selects will not help a bit.

Regards,

Sybrand Bakker, Oracle DBA

"Eugenio" <eugenio.spadafora_nospam_at_compaq.com> wrote in message news:8icvno$29m$1_at_mailint03.im.hou.compaq.com...
> 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