RE: wrong display of year

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Tue, 9 Jan 2001 07:51:46 +0400
Message-Id: <10735.126071@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_01C079EF.7C9B96D0
Content-Type: text/plain;

charset="iso-8859-1"

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

Thanks,
Amar Kumar Padhi
Software Consultant

-----Original Message-----
From: grace lim [mailto:mglim_at_softhome.net] Sent: Tuesday, January 09, 2001 6:50 AM
To: Multiple recipients of list ORACLE-L Subject: wrong display of year

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).

------_=_NextPart_001_01C079EF.7C9B96D0
Content-Type: text/html;
	charset="iso-8859-1"

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

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

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

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: grace lim [<A HREF="mailto:mglim_at_softhome.net">mailto:mglim_at_softhome.net</A>]</FONT>
<BR><FONT SIZE=2>Sent: Tuesday, January 09, 2001 6:50 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: wrong display of year</FONT>
</P>
<BR>

<P><FONT SIZE=2>gurus,</FONT>
</P>

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

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

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

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

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

Received on Mon Jan 08 2001 - 21:51:46 CST