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(at)innominate(dot)de
innominate AG
networking people
fon: +49.30.308806-11 fax: -77 web: http://innominate.de pgp: /pgp/tm