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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Sun, 30 Aug 2009 12:45:33 -0600
  • Message-id: <200908301245.33426.kevink@consistentstate.com> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group