In article <OFC94B0A45(dot)89F8C8AE-ON85256CCD(dot)0075A6DD(at)jc(dot)jefco(dot)com>,
<STashlitsky(at)JEFCO(dot)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.