Search Postgresql Archives

convert epoch to date

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
Subject: convert epoch to date
From: Kevin Kempter <kevink@xxxxxxxxxxxxxxxxxxx>
Date: Sun, 30 Aug 2009 12:45:33 -0600
Organization: Consistent State
User-agent: KMail/1.12.0 (Linux/2.6.27.30-170.2.82.fc10.x86_64; KDE/4.3.0; x86_64; ; )

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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: convert epoch to date
  - From: Pavel Stehule

Prev by Date: Connecting to Teradata via Postgresql
Next by Date: Re: Connecting to Teradata via Postgresql
Previous by thread: Connecting to Teradata via Postgresql
Next by thread: Re: convert epoch to date
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux