RE: wrong display of year

Message-Id: <10735.126078@fatcity.com> From: Amar Kumar Padhi Date: Tue, 9 Jan 2001 09:14:41 +0400 Subject: RE: wrong display of year This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C079FB.1269F520 Content-Type: text/plain; charset="iso-8859-1" Check the manuals, have exhaustive notes there. It is basically oracle's way of warding of y2k bug depending on the system year and the yy format year entered by the user. eg: -select * from am04; COL1 _________ 01-JAN-99 01-JAN-01 -select to_char(to_date(col1,'dd/mm/yyyy'),'dd/mm/yyyy') from am04; TO_CHAR(TO __________ 01/01/0099 01/01/0001 -select to_char(to_date(col1,'dd/mm/rrrr'),'dd/mm/yyyy') from am04; TO_CHAR(TO __________ 01/01/1999 01/01/2001 Thanks, Amar Kumar Padhi Software Consultant -----Original Message----- From: Viswalingam Mohan [mailto:Viswalingam_Mohan@ril.com] Sent: Tuesday, January 09, 2001 8:36 AM To: Multiple recipients of list ORACLE-L Subject: RE: wrong display of year dear all what is this 'mm/dd/rrrr' format i tried it but ?? Please respond to ORACLE-L@fatcity.com To: Multiple recipients of list ORACLE-L cc: (bcc: Viswalingam Mohan/JAMNAGAR/RIL) known problem, use the RRRR format. 'mm/dd/rrrr' Thanks, Amar Kumar Padhi Software Consultant -----Original Message----- Sent: Tuesday, January 09, 2001 6:50 AM To: Multiple recipients of list ORACLE-L gurus, when i issue a select command to display date in mm/dd/yyyy format , the year 1999 is displayed as 2099. select to_char(process_date,'MM/DD/YYYY) from TEST; PROCESS_DATE ---------------------- 01-01-2099 02-03-2000 what can i do to correct this? Grace Lim Suy Sing Comm'l Corp. (063)-02-247-41-34 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace lim INET: mglim@softhome.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viswalingam Mohan INET: Viswalingam_Mohan@ril.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C079FB.1269F520 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: wrong display of year

Check the manuals, have exhaustive notes = there.
It is basically oracle's way of warding of y2k bug = depending on the system year and the yy format year entered by the = user.

eg:
-select * from am04;
COL1
_________
01-JAN-99
01-JAN-01
-select = to_char(to_date(col1,'dd/mm/yyyy'),'dd/mm/yyyy') from am04;

TO_CHAR(TO
__________
01/01/0099
01/01/0001

-select = to_char(to_date(col1,'dd/mm/rrrr'),'dd/mm/yyyy') from am04;

TO_CHAR(TO
__________
01/01/1999
01/01/2001

Thanks,
Amar Kumar Padhi
Software Consultant

-----Original Message-----
From: Viswalingam Mohan [mailto:Viswalingam_Mohan@ril.c= om]
Sent: Tuesday, January 09, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: wrong display of year

dear all
what is this 'mm/dd/rrrr' format i tried it but = ??

Please respond to ORACLE-L@fatcity.com

To: Multiple recipients of list ORACLE-L = <ORACLE-L@fatcity.com>
cc: (bcc: Viswalingam = Mohan/JAMNAGAR/RIL)

known problem,
use the RRRR format.
'mm/dd/rrrr'

Thanks,
Amar Kumar Padhi
Software Consultant

-----Original Message-----
Sent: Tuesday, January 09, 2001 6:50 AM
To: Multiple recipients of list ORACLE-L

gurus,

when i issue a select command to display date in = mm/dd/yyyy format , the
year 1999 is displayed as 2099.

select to_char(process_date,'MM/DD/YYYY) from = TEST;

PROCESS_DATE
----------------------
01-01-2099
02-03-2000

what can i do to correct this?
Grace Lim
Suy Sing Comm'l Corp.
(063)-02-247-41-34
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: grace lim
INET: mglim@softhome.net

Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051
San Diego, = California -- Public Internet = access / Mailing Lists
---------------------------------------------------------------= -----
To REMOVE yourself from this mailing list, send an = E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of = 'ListGuru') and in
the message BODY, include a line containing: UNSUB = ORACLE-L
(or the name of mailing list you want to be removed = from). You may
also send the HELP command for other information = (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viswalingam Mohan
INET: Viswalingam_Mohan@ril.com