Re: epoch to timestamp - Mailing list pgsql-sql

From Larry Rosenman
Subject Re: epoch to timestamp
Date
Msg-id 84320000.1052753190@lerlaptop.iadfw.net
Whole thread Raw
In response to Re: epoch to timestamp  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: epoch to timestamp  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql

--On Monday, May 12, 2003 18:30:11 -0200 Achilleus Mantzios 
<achill@matrix.gatewaynet.com> wrote:

> On Mon, 12 May 2003, Lucas Lain wrote:
>
>> i really dont know how to do it ... i'm a newbie
>> it is something like this?
>>
>> select cast(105471234 AS abstime) ...
>>
>> and then?
>
> Just do
> select 105471234::abstime::timestamp;
>
Along the same lines, how can I get from seconds to hour/minute/seconds?

(an interval?)


-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749



pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: epoch to timestamp
Next
From: Lucas Lain
Date:
Subject: Re: epoch to timestamp