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

From miquels@cistron-office.nl (Miquel van Smoorenburg)
Subject Re: convert from an integer to a date
Date
Msg-id b2reh8$a30$1@news.cistron.nl
Whole thread Raw
In response to convert from an integer to a date  (STashlitsky@JEFCO.com)
List pgsql-sql
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.



pgsql-sql by date:

Previous
From: "Tambet Matiisen"
Date:
Subject: Re: select from update from select?
Next
From: Jan Wieck
Date:
Subject: Re: Drop temporary table only if it exists