From: STashlitsky@JEFCO.com
To: pgsql-sql@postgresql.org
Subject: convert from an integer to a date
Date: Fri, 14 Feb 2003 16:33:09 -0500
Message-ID: <OFC94B0A45.89F8C8AE-ON85256CCD.0075A6DD@jc.jefco.com> (raw)
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 produced at the request of regulators or in connection with civil litigation. Jefferies accepts no liability for any errors or omissions arising as a result of transmission. Use by other than intended recipients is prohibited.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: STashlitsky@JEFCO.com
Subject: Re: convert from an integer to a date
In-Reply-To: <OFC94B0A45.89F8C8AE-ON85256CCD.0075A6DD@jc.jefco.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox