Re: Converting epoch to timestamp?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Converting epoch to timestamp?
Дата
Msg-id web-95041@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на Re: Converting epoch to timestamp?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Tom,

> regression=# select timestamp(996673954);
>        timestamp
> ------------------------
>  2001-08-01 09:52:34-04
> (1 row)
> 
> (This last didn't use to work, but it seems fine in 7.0 and 7.1.  It
> will fail in 2038 when timestamps stop looking like int4, but by then
> hopefully we'll have changed things...)

Yeah, sure.  That's what my father said in 1964 when they talked about
the potential problems with 2-digit dates on the UNIVAC II ...

;-)

-Josh


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


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

Предыдущее
От: "Michael Richards"
Дата:
Сообщение: Exclusion List
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Exclusion List