Unix time stamp function?

From: Steve Micallef <stevenm(at)ot(dot)com(dot)au>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Unix time stamp function?
Date: 2001-06-13 00:38:30
Message-ID: 20010613103614.W37166-100000@toaster.syd.ot
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I store Unix time stamps (seconds since Jan 1 1970) in my database. I was
hoping there was an SQL/PostgreSQL function for converting a unix time
stamp into a readable date/time string?

I've searched the documentation, and there only seems to be functions
which deal with time stamps (XXXX-XX-XX XX:XX:XX).

Thanks in advance,

Steve Micallef

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2001-06-13 02:23:15 Re: Re: Does PostgreSQL support EXISTS?
Previous Message Tom Lane 2001-06-13 00:24:08 Re: PLPGSQL: Using SELECT INTO and EXECUTE