Re: 2001 vs 2000 Problem

The point is that it is the wrong date. It should return 01-jan-1901

In article <DJn0ox.6pz_at_nntpa.cb.att.com>, Govindhan Padmavijayam <govind_at_bns01.attmail.com> writes:
|> Bob,
|>
|> The following Query, does what you need. Think the reason you're getting
|> 1900, is because "we are not there yet", ( Our NLS_DATE_FORMAT is set to
|> mm/dd/rr in the INIT<sid>.ora ).
|>
|> SELECT 'X' FROM DUAL
|> WHERE
|> SYSDATE < TRUNC(TO_DATE('01/01/00','MM/DD/RR'),'CC')
|> /
|>
|> will do what you need to.
|>
|> hth,
|> Govindhan Padmavijayam
|>
|> jern_at_polecat.jhuapl.edu (Bob Jernigan) wrote:
|> >trunc(sysdate,'CC') returns 01-Jan-1900.
|> >
|> >Anyone else noticed this?
|> >
|> >bob
|>
Received on Fri Dec 15 1995 - 00:00:00 CET