Re: RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
Дата
Msg-id 4748.1063201263@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?  ("Bruno BAGUETTE" <pgsql-ml@baguette.net>)
Список pgsql-general
"Bruno BAGUETTE" <pgsql-ml@baguette.net> writes:
>> Sooner or later we'll probably invent an explicit function to do this
>> conversion.

> I may be wrong but why create a new fonction for unixtimestamp<-->date
> conversion ?

> I think that the to_date() function is the best place to add this kind
> of conversion.

to_date doesn't seem particularly appropriate.  There's no use for a
format string in this context, and there isn't any variant of to_date
that accepts an integer as input anyway.

            regards, tom lane

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

Предыдущее
От: "Jules Alberts"
Дата:
Сообщение: help with TCL function
Следующее
От: Guy Fraser
Дата:
Сообщение: Re: Picture with Postgres and Delphi