Re: converting big int to date

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: Sree <mail2mail(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: converting big int to date
Date: 2011-03-24 16:30:48
Message-ID: CDD3B7F6-92AD-4B06-9116-4216BCAEA8BA@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Mar 24, 2011, at 2:42 AM, Sree wrote:

> How can i convert bigint to date format.
>
> bigint=616962528000000000

Please explain what;s this value shows.

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jasen Betts 2011-03-26 10:04:43 Re: converting big int to date
Previous Message Viktor Bojović 2011-03-24 07:49:28 Re: pg_attributte, data types