getting extract to always return number of hours

Поиск
Список
Период
Сортировка
От Chris
Тема getting extract to always return number of hours
Дата
Msg-id 4B43E887.6040402@gmail.com
обсуждение исходный текст
Ответы Re: getting extract to always return number of hours  (Rosser Schwarz <rosser.schwarz@gmail.com>)
Re: getting extract to always return number of hours  (Chris <dmagick@gmail.com>)
Список pgsql-sql
Hi,

I'm trying to get extract() to always return the number of hours between 
two time intervals, ala:

=> create table t1(timestart timestamp, timeend timestamp);
=> insert into t1(timestart, timeend) values ('2010-01-01 00:00:00', 
'2010-01-02 01:00:00');

=> select timeend - timestart from t1;    ?column?
---------------- 1 day 01:00:00
(1 row)

to return 25 hours.

I couldn't see anything in the docs and can't work out a way to do it.

Any suggestions?

Thanks!
-- 
Postgresql & php tutorials
http://www.designmagick.com/



В списке pgsql-sql по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: Proper case function
Следующее
От: Rosser Schwarz
Дата:
Сообщение: Re: getting extract to always return number of hours