Re: [GENERAL] convert epoch to date

2009-08-30 Thread Pavel Stehule
Hello 2009/8/30 Kevin Kempter : > Hi all; > > I know how to convert a date to an epoch: > > select extract ('epoch' from timestamp '2009-08-12') > postgres=# select extract ('epoch' from timestamp '2009-08-12'); date_part 1250028000 (1 row) Time: 0,734 ms postgres=# select to_time

[GENERAL] convert epoch to date

2009-08-30 Thread Kevin Kempter
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@postgresql.org) To make changes to your subscript