Home > mailing lists

Unix time stamp function? - Mailing list pgsql-general

From	Steve Micallef
Subject	Unix time stamp function?
Date	June 12, 2001 23:40:24
Msg-id	20010613103614.W37166-100000@toaster.syd.ot Whole thread Raw
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Tom Lane
Date: 12 June 2001, 23:24:24
Subject: Re: PLPGSQL: Using SELECT INTO and EXECUTE

From: Martijn van Oosterhout
Date: 13 June 2001, 01:23:39
Subject: Re: Re: Does PostgreSQL support EXISTS?

Unix time stamp function? - Mailing list pgsql-general

Previous

Next