Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: wrong display of year

RE: wrong display of year

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Tue, 9 Jan 2001 09:14:41 +0400
Message-Id: <10735.126078@fatcity.com> 





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_at_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_at_fatcity.com



To:   Multiple recipients of list ORACLE-L <ORACLE-L_at_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_at_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_at_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_at_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_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>RE: wrong display of year</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Check the manuals, have exhaustive notes =
there.</FONT>
<BR><FONT SIZE=3D2>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.</FONT></P>

<P><FONT SIZE=3D2>eg:</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; -select * from am04;</FONT>
<BR><FONT SIZE=3D2>COL1</FONT>
<BR><FONT SIZE=3D2>_________</FONT>
<BR><FONT SIZE=3D2>01-JAN-99</FONT>
<BR><FONT SIZE=3D2>01-JAN-01</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; -select =
to_char(to_date(col1,'dd/mm/yyyy'),'dd/mm/yyyy') from am04;</FONT>
</P>

<P><FONT SIZE=3D2>TO_CHAR(TO</FONT>
<BR><FONT SIZE=3D2>__________</FONT>
<BR><FONT SIZE=3D2>01/01/0099</FONT>
<BR><FONT SIZE=3D2>01/01/0001</FONT>
</P>

<P><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; -select =
to_char(to_date(col1,'dd/mm/rrrr'),'dd/mm/yyyy') from am04;</FONT>
</P>

<P><FONT SIZE=3D2>TO_CHAR(TO</FONT>
<BR><FONT SIZE=3D2>__________</FONT>
<BR><FONT SIZE=3D2>01/01/1999</FONT>
<BR><FONT SIZE=3D2>01/01/2001</FONT>
</P>

<P><FONT SIZE=3D2>Thanks,</FONT>
<BR><FONT SIZE=3D2>Amar Kumar Padhi</FONT>
<BR><FONT SIZE=3D2>Software Consultant</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Viswalingam Mohan [<A =
HREF=3D"mailto:Viswalingam_Mohan_at_ril.com">mailto:Viswalingam_Mohan_at_ril.c=
om</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, January 09, 2001 8:36 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: RE: wrong display of year</FONT>
</P>
<BR>
<BR>
<BR>

<P><FONT SIZE=3D2>dear all</FONT>
<BR><FONT SIZE=3D2>what is this 'mm/dd/rrrr' format i tried it but =
??</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=3D2>Please respond to ORACLE-L_at_fatcity.com</FONT>
</P>

<P><FONT SIZE=3D2>To:&nbsp;&nbsp; Multiple recipients of list ORACLE-L =
&lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=3D2>cc:&nbsp;&nbsp;&nbsp; (bcc: Viswalingam =
Mohan/JAMNAGAR/RIL)</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=3D2>known problem,</FONT>
<BR><FONT SIZE=3D2>use the RRRR format.</FONT>
<BR><FONT SIZE=3D2>'mm/dd/rrrr'</FONT>
</P>

<P><FONT SIZE=3D2>Thanks,</FONT>
<BR><FONT SIZE=3D2>Amar Kumar Padhi</FONT>
<BR><FONT SIZE=3D2>Software Consultant</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, January 09, 2001 6:50 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>gurus,</FONT>
</P>

<P><FONT SIZE=3D2>when i issue a select command to display date in =
mm/dd/yyyy format , the</FONT>
<BR><FONT SIZE=3D2>year 1999 is displayed as 2099.</FONT>
</P>

<P><FONT SIZE=3D2>select&nbsp; to_char(process_date,'MM/DD/YYYY) from =
TEST;</FONT>
</P>

<P><FONT SIZE=3D2>PROCESS_DATE</FONT>
<BR><FONT SIZE=3D2>----------------------</FONT>
<BR><FONT SIZE=3D2>01-01-2099</FONT>
<BR><FONT SIZE=3D2>02-03-2000</FONT>
</P>

<P><FONT SIZE=3D2>what can i do to correct this?</FONT>
<BR><FONT SIZE=3D2>Grace Lim</FONT>
<BR><FONT SIZE=3D2>Suy Sing Comm'l Corp.</FONT>
<BR><FONT SIZE=3D2>(063)-02-247-41-34</FONT>
<BR><FONT SIZE=3D2>--</FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>--</FONT>
<BR><FONT SIZE=3D2>Author: grace lim</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: mglim_at_softhome.net</FONT>
</P>

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


(like subscribing).</FONT>

</P>
<BR>
<BR>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Viswalingam Mohan</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: Viswalingam_Mohan_at_ril.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =


Received on Mon Jan 08 2001 - 23:14:41 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US