Thread: unixtime -> datetime

hi,

i was wondering if there was a built-in function for converting unix
time (seconds since the epoch) to postgresql's datetime type.

i was looking for something like this (but couldn't find it):
   SELECT unixtime(943948651);

and want to get something like this:
   foo   ----------------------   1999-11-30 09:06:43+01   (1 row)

any ideas?

thilo


-- 
mezger@innominate.de                                                       innominate AG
                  networking people
 
fon: +49.30.308806-11 fax: -77 web: http://innominate.de pgp: /pgp/tm