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

From: "Bruno BAGUETTE" <pgsql-ml(at)baguette(dot)net>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-general(at)postgresql(dot)org>
Subject: RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
Date: 2003-09-10 08:05:48
Message-ID: !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAA42Sh/VTqQ0WUipWJyx5c+QEAAAAA@baguette.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)baguette(dot)net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thierry Missimilly 2003-09-10 08:14:32 Postgres 7.4Beta2 Thread-safe
Previous Message Bruno BAGUETTE 2003-09-10 08:02:20 RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?