On 2011-03-23, Sree <mail2m...@gmail.com> wrote:
> --90e6ba2123fbe15f02049f2ccf73
> Content-Type: text/plain; charset=ISO-8859-1
>
> How can i convert bigint to date format.
>
> bigint=616962528000000000
that's got the right number of zeros to
be a date expressed as microseconds since epoch
in which case the magic spell is
select 'epoch'::timestamptz
+ '1s'::interval
* (616962528000000000::bigint /1000000000.0);
gives me a date in 1989
if it's some from a microsoft inspored system instead of AT&T inspired
you might need to add '10 years'::interval to the result.
--
⚂⚃ 100% natural
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
