Re: 2001 vs 2000 Problem
From: Govindhan Padmavijayam <govind_at_bns01.attmail.com>
Date: 1995/12/15
Message-ID: <DJn0ox.6pz_at_nntpa.cb.att.com>#1/1
Date: 1995/12/15
Message-ID: <DJn0ox.6pz_at_nntpa.cb.att.com>#1/1
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
will do what you need to.
hth,
jern_at_polecat.jhuapl.edu (Bob Jernigan) wrote:
WHERE
SYSDATE < TRUNC(TO_DATE('01/01/00','MM/DD/RR'),'CC')
/
Govindhan Padmavijayam
>
>Anyone else noticed this?
>
>bob
Received on Fri Dec 15 1995 - 00:00:00 CET