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