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 !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAAX7OIsWF9LEylYbojYVdBygEAAAAA@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>)
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: froggle2003@yahoo.com (Alex Martinoff)
Date:
Subject: Constructing column from different individual fields in same row.
Next
From: Bruno Wolff III
Date:
Subject: Re: Constructing column from different individual fields in same row.