Re: epoch to date?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Alex Rice <alrice(at)ARCplanning(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: epoch to date?
Date: 2003-05-08 19:54:41
Message-ID: 20030508195441.GB4152@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, May 08, 2003 at 13:44:22 -0600,
Alex Rice <alrice(at)ARCplanning(dot)com> wrote:
> I have a column with seconds since the unix epoch. How to convert it to
> date? Sorry I couldn't find it in the docs.

One way is:
select 'epoch'::timestamp + 1234 * '1 second'::interval;

Another is:
select 1234::abstime;

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message foo2 2003-05-09 02:01:09 Anyone know of a text-interface postmaster load monitor?
Previous Message Alex Rice 2003-05-08 19:44:49 Re: does this require a stored procedure?