From: | Thilo Mezger <mezger(at)innominate(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | unixtime -> datetime |
Date: | 1999-11-30 08:07:35 |
Message-ID: | 8200k7$1ff$1@lingo01.bln.innominate.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick JACQUOT | 1999-11-30 12:07:26 | found a way to update a table with data from another one |
Previous Message | Bruce Momjian | 1999-11-30 03:13:59 | Re: [SQL] NULL |