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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group