convert from an integer to a date - Mailing list pgsql-sql

From STashlitsky@JEFCO.com
Subject convert from an integer to a date
Date
Msg-id OFC94B0A45.89F8C8AE-ON85256CCD.0075A6DD@jc.jefco.com
Whole thread Raw
Responses Re: convert from an integer to a date  (Frank Bax <fbax@sympatico.ca>)
List pgsql-sql
<br /><font face="sans-serif" size="2">When I run </font><font color="blue" face="MS Sans Serif"
size="1">select</font><fontface="MS Sans Serif" size="1"> to_date('20030212','YYYYMMDD') the output is
2/12/03</font><br/><font face="MS Sans Serif" size="1">if I run </font><font color="blue" face="MS Sans Serif"
size="1">select</font><fontface="MS Sans Serif" size="1"> to_date( to_char(20030212,99999999),'YYYYMMDD'); the output
is6/23/05</font><br /><br /><font face="MS Sans Serif" size="1">How can I convert from integer into date format
correctly?</font><br/><br /><font face="MS Sans Serif" size="1">Thanks for any help with this.</font><br /><br /><font
face="MSSans Serif" size="1">Svetlana</font><br /><br /><font color="#000000" face="Helv" size="3"></font><br /><font
color="#000000"face="Helv" size="3"></font><br /><font color="#000000" face="Helv" size="3"></font><br /><font
color="#000000"face="Helv" size="3">Jefferies archives and reviews outgoing and incoming e-mail. It may be produced at
therequest of regulators or in connection with civil litigation. Jefferies accepts no liability for any errors or
omissionsarising as a result of transmission. Use by other than intended recipients is prohibited.</font><br /> 

pgsql-sql by date:

Previous
From: "Eduardo"
Date:
Subject: Re: PL/PGSQL EDITOR
Next
From: "V. Cekvenich"
Date:
Subject: Fwd: Re: Table Pivot