Re: Format intervall as hours/minutes etc - Mailing list pgsql-sql

From Andreas Kretschmer
Subject Re: Format intervall as hours/minutes etc
Date
Msg-id 20070916111427.GA13886@KanotixBox
Whole thread Raw
In response to Format intervall as hours/minutes etc  (Andreas Joseph Krogh <andreak@officenet.no>)
Responses Re: Format intervall as hours/minutes etc
List pgsql-sql
Andreas Joseph Krogh <andreak@officenet.no> schrieb:

> Hi all. Any hint on how to format this interval as number of hour/seconds etc?
> select age('2007-09-22 17:00'::timestamp, '2000-02-20 18:00'::timestamp);
>               age
> -------------------------------
>  7 years 7 mons 1 day 23:00:00

You can use extract(epoch, from ...) like this:

test=*# select extract(epoch from '2007-09-22 17:00'::timestamp) - extract (epoch from '2000-02-20
18:00'::timestamp);?column?
-----------239407200
(1 row)

Now you can calculate the hours and so on.

Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


pgsql-sql by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Format intervall as hours/minutes etc
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: Format intervall as hours/minutes etc