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

From: "Bruno BAGUETTE" <bouchon(dot)web(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:02:20
Message-ID: !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAAX7OIsWF9LEylYbojYVdBygEAAAAA@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

Browse pgsql-general by date

  From Date Subject
Next Message Bruno BAGUETTE 2003-09-10 08:05:48 RE : How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
Previous Message Stéphane Cazeaux 2003-09-10 07:34:15 Question about conccurrency control and Insert