Postgres Pro
Downloads
Home   >   mailing lists

Re: epoch to timestamp - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: epoch to timestamp
Date
Msg-id 20030509213648.GA13124@wolff.to
Whole thread Raw
In response to epoch to timestamp  (Lucas Lain <lainl@aconectarse.com>)
Responses Re: epoch to timestamp  (Lucas Lain <lainl@aconectarse.com>)
List pgsql-sql
Tree view 
On Fri, May 09, 2003 at 18:05:45 -0300, Lucas Lain <lainl@aconectarse.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.

pgsql-sql by date:

Previous
From: Lucas Lain
Date:
Subject: epoch to timestamp
Next
From: Ian Barwick
Date:
Subject: Using psql to insert character codes