X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id C53D3475EF0
	for <pgsql-sql@postgresql.org>; Fri, 14 Feb 2003 16:51:20 -0500 (EST)
Received: from SMTPEAST.JC.JEFCO.COM (fwjc1.jefco.com [204.253.68.19])
	by postgresql.org (Postfix) with ESMTP id 09CF54765D7
	for <pgsql-sql@postgresql.org>; Fri, 14 Feb 2003 16:33:27 -0500 (EST)
Received: from eastmail1.jc.jefco.com ([169.196.21.61]) by
	SMTPEAST.JC.JEFCO.COM
	(Lotus Domino Release 5.0.11) with ESMTP id 2003021416315442:115975
	;          Fri, 14 Feb 2003 16:31:54 -0500
To: pgsql-sql@postgresql.org
Subject: convert from an integer to a date
MIME-Version: 1.0
X-Mailer: Lotus Notes Release 5.0.7  March 21, 2001
Message-ID: <OFC94B0A45.89F8C8AE-ON85256CCD.0075A6DD@jc.jefco.com>
From: STashlitsky@JEFCO.com
Date: Fri, 14 Feb 2003 16:33:09 -0500
X-MIMETrack: Serialize by Router on EASTMAIL1/JEFCO(Release 5.0.10 |March 22,
	2002) at 02/14/2003 04:33:13 PM,
	Serialize complete at 02/14/2003 04:33:13 PM,
	Itemize by SMTP Server on SMTPEAST/JEFCO(Release 5.0.11  |July 24,
	2002) at 02/14/2003 04:31:54 PM,
	Serialize by Router on SMTPEAST/JEFCO(Release 5.0.11  |July 24,
	2002) at 02/14/2003 04:32:08 PM,
	Serialize complete at 02/14/2003 04:32:08 PM
Content-Type: multipart/alternative;
	boundary="=_alternative 007660E805256CCD_="
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/376
X-Sequence-Number: 11774

This is a multipart message in MIME format.
--=_alternative 007660E805256CCD_=
content-type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: Quoted-Printable

When I run select to_date('20030212','YYYYMMDD') the output is 2/12/03
if I run select to_date( to_char(20030212,99999999),'YYYYMMDD'); the output=
 is 6/23/05

How can I convert from integer into date format correctly?

Thanks for any help with this.

Svetlana




Jefferies archives and reviews outgoing and incoming e-mail.  It may be pro=
duced at the request of regulators or in connection with civil litigation. =
Jefferies accepts no liability for any errors or omissions arising as a res=
ult of  transmission. Use by other than intended recipients is prohibited.


--=_alternative 007660E805256CCD_=
content-type: text/html; charset="us-ascii"
Content-Transfer-Encoding: Quoted-Printable


<br><font size=3D2 face=3D"sans-serif">When I run </font><font size=3D1 col=
or=3Dblue face=3D"MS Sans Serif">select</font><font size=3D1 face=3D"MS San=
s Serif"> to_date('20030212','YYYYMMDD') the output is 2/12/03</font>
<br><font size=3D1 face=3D"MS Sans Serif">if I run </font><font size=3D1 co=
lor=3Dblue face=3D"MS Sans Serif">select</font><font size=3D1 face=3D"MS Sa=
ns Serif"> to_date( to_char(20030212,99999999),'YYYYMMDD'); the output is 6=
/23/05</font>
<br>
<br><font size=3D1 face=3D"MS Sans Serif">How can I convert from integer in=
to date format correctly?</font>
<br>
<br><font size=3D1 face=3D"MS Sans Serif">Thanks for any help with this.</f=
ont>
<br>
<br><font size=3D1 face=3D"MS Sans Serif">Svetlana</font>
<br>
<br><font face=3D"Helv" size=3D3 color=3D#000000 ></font><br><font face=3D"=
Helv" size=3D3 color=3D#000000 ></font><br><font face=3D"Helv" size=3D3 col=
or=3D#000000 ></font><br><font face=3D"Helv" size=3D3 color=3D#000000 >Jeff=
eries archives and reviews outgoing and incoming e-mail.  It may be produce=
d at the request of regulators or in connection with civil litigation. Jeff=
eries accepts no liability for any errors or omissions arising as a result =
of  transmission. Use by other than intended recipients is prohibited.</fon=
t><br>

--=_alternative 007660E805256CCD_=--