Skip site navigation (1) Skip section navigation (2)

unixtime -> datetime

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 (view raw or flat)
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

pgsql-sql by date

Next:From: Patrick JACQUOTDate: 1999-11-30 12:07:26
Subject: found a way to update a table with data from another one
Previous:From: Bruce MomjianDate: 1999-11-30 03:13:59
Subject: Re: [SQL] NULL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group