convert integer seconds to timestamp

From: Wilson Fletcher <research(at)mclachlan(dot)com(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: convert integer seconds to timestamp
Date: 2003-10-16 03:31:11
Message-ID: 20031016133111.A7731@mclachlan.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

How can I convert epoch seconds (as an interger) to a timestamp ?

I've already seen the post below BUT it doesn't work. I suspect it is out of date:
http://archives.postgresql.org/pgsql-sql/2000-09/msg00190.php

thanks.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Wilson Fletcher 2003-10-16 03:39:40 Re: convert integer seconds to timestamp
Previous Message Josh Berkus 2003-10-15 22:15:43 Re: Calc