Re: How to typecast an integer into a timestamp?

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: How to typecast an integer into a timestamp?
Дата
Msg-id 201201280715.19863.adrian.klaver@gmail.com
обсуждение исходный текст
Ответ на Re: How to typecast an integer into a timestamp?  (Bruno Boettcher <bboett@bboett.adlp.org>)
Список pgsql-general
On Saturday, January 28, 2012 1:43:43 am Bruno Boettcher wrote:
> On Fri, Jan 27, 2012 at 08:17:37AM -0800, Adrian Klaver wrote:
> > Did some digging. php-mktime returns the Unix epoch (seconds since
> > January 1 1970 00:00:00 GMT)
>
> indeed, didn't get it that postgres timestamp wasn't the same....

Well internally they are stored that way.  You just have to input the
values as some sort of time/date/timestamp string. For all the details see here:

http://www.postgresql.org/docs/9.0/interactive/datatype-datetime.html#DATATYPE-DATETIME-INPUT

>
>   ciao
>   Bruno

--
Adrian Klaver
adrian.klaver@gmail.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruno Boettcher
Дата:
Сообщение: Re: How to typecast an integer into a timestamp?
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: Multi master use case?