Re: epoch to timestamp - Mailing list pgsql-sql

From Lucas Lain
Subject Re: epoch to timestamp
Date
Msg-id 20030512120544.5bb9c4c6.lainl@aconectarse.com
Whole thread Raw
In response to Re: epoch to timestamp  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: epoch to timestamp  (Randall Lucas <rlucas@tercent.net>)
Re: epoch to timestamp  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql
i really dont know how to do it ... i'm a newbie
it is something like this?

select cast(105471234 AS abstime) ... 

and then? 



On Fri, 9 May 2003 16:36:48 -0500
Bruno Wolff III <bruno@wolff.to> wrote:

> 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.
> 


-- 
Lucas Lain
lainl@aconectarse.com



pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: insert rowtype
Next
From: Randall Lucas
Date:
Subject: Re: epoch to timestamp