Hello
2009/8/30 Kevin Kempter <kevink@xxxxxxxxxxxxxxxxxxx>:
> 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_timestamp(1250028000);
to_timestamp
------------------------
2009-08-12 00:00:00+02
(1 row)
regards
Pavel Stehule
>
> 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
>
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
