Skip site navigation (1) Skip section navigation (2)

convert epoch to date

From: Kevin Kempter <kevink(at)consistentstate(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: convert epoch to date
Date: 2009-08-30 18:45:33
Message-ID: 200908301245.33426.kevink@consistentstate.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi all;

I know how to convert a date to an epoch:

select extract ('epoch' from timestamp '2009-08-12')


How do I do the opposite, I want to convert epoch values to a date


Thanks in advance

Responses

pgsql-general by date

Next:From: David FetterDate: 2009-08-30 19:13:39
Subject: Re: Connecting to Teradata via Postgresql
Previous:From: Ow Mun HengDate: 2009-08-30 15:21:55
Subject: Connecting to Teradata via Postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group