From: miquels@cistron-office.nl
To: pgsql-sql@postgresql.org
Subject: Re: convert from an integer to a date
Date: Mon, 17 Feb 2003 19:52:08 +0000 (UTC)
Message-ID: <b2reh8$a30$1@news.cistron.nl> (raw)
References: <OFC94B0A45.89F8C8AE-ON85256CCD.0075A6DD@jc.jefco.com>
In article <OFC94B0A45.89F8C8AE-ON85256CCD.0075A6DD@jc.jefco.com>,
<STashlitsky@JEFCO.com> wrote:
>How can I convert from integer into date format correctly?
traffic=# select date(20030212);
date
------------
2003-02-12
(1 row)
or
traffic=# select 20030212::text::date;
date
------------
2003-02-12
(1 row)
Mike.
--
Anyone who is capable of getting themselves made President should
on no account be allowed to do the job -- Douglas Adams.
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: miquels@cistron-office.nl
Subject: Re: convert from an integer to a date
In-Reply-To: <b2reh8$a30$1@news.cistron.nl>
* 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