Re: convert from an integer to a date

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.