Re: RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ? - Mailing list pgsql-general

From Tom Lane
Subject Re: RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
Date
Msg-id 4748.1063201263@sss.pgh.pa.us
Whole thread Raw
In response to RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?  ("Bruno BAGUETTE" <pgsql-ml@baguette.net>)
List 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 by date:

Previous
From: "Jules Alberts"
Date:
Subject: help with TCL function
Next
From: Guy Fraser
Date:
Subject: Re: Picture with Postgres and Delphi