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

From Bruno BAGUETTE
Subject RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
Date
Msg-id !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAA42Sh/VTqQ0WUipWJyx5c+QEAAAAA@baguette.net
Whole thread Raw
In response to Re: How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> 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. Isn't it better to add a new value for the second
parameter of the to_date function ?

Regards,

---------------------------------------
Bruno BAGUETTE - pgsql-ml@baguette.net


pgsql-general by date:

Previous
From: Stéphane Cazeaux
Date:
Subject: Question about conccurrency control and Insert
Next
From: Thierry Missimilly
Date:
Subject: Postgres 7.4Beta2 Thread-safe