Re: epoch to timestamp - Mailing list pgsql-sql

From Achilleus Mantzios
Subject Re: epoch to timestamp
Date
Msg-id Pine.LNX.4.44.0305121839190.18329-100000@matrix.gatewaynet.com
Whole thread Raw
In response to Re: epoch to timestamp  (Larry Rosenman <ler@lerctr.org>)
Responses Re: epoch to timestamp  (Larry Rosenman <ler@lerctr.org>)
List pgsql-sql
On Mon, 12 May 2003, Larry Rosenman wrote:

As an example see:

select date_part('minute',(105471234::abstime::timestamp) + ('10 
years')::interval);

> >
> Along the same lines, how can I get from seconds to hour/minute/seconds?
> 
> (an interval?)
> 
> 
> 

-- 
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-210-8981112
fax:    +30-210-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr



pgsql-sql by date:

Previous
From: Lucas Lain
Date:
Subject: Re: epoch to timestamp
Next
From: Larry Rosenman
Date:
Subject: Re: epoch to timestamp