Re: epoch to timestamp

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Lucas Lain <lainl(at)aconectarse(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: epoch to timestamp
Date: 2003-05-09 21:36:48
Message-ID: 20030509213648.GA13124@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On Fri, May 09, 2003 at 18:05:45 -0300,
Lucas Lain <lainl(at)aconectarse(dot)com> wrote:
>
> can anyone tell me how to convert an epoch date to timestamp format??

If the epoch date is an integer with seconds since the unix epoch,
you can cast it to abstime and then to timestamp.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Keary Suska 2003-05-09 22:29:03 Re: semget: No space left on device
Previous Message Lucas Lain 2003-05-09 21:05:45 epoch to timestamp

Browse pgsql-sql by date

  From Date Subject
Next Message Ian Barwick 2003-05-10 14:20:24 Using psql to insert character codes
Previous Message Filipe Bonjour 2003-05-09 21:21:25 Can arrays reference primary keys in CREATE TABLE?