Обсуждение: convert epoch to date

Поиск
Список
Период
Сортировка

convert epoch to date

От
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

Re: convert epoch to date

От
Pavel Stehule
Дата:
Hello

2009/8/30 Kevin Kempter <kevink@consistentstate.com>:
> 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>