Postgres Pro
Downloads
Home   >   mailing lists

time difference - Mailing list pgsql-sql

From q u a d r a
Subject time difference
Date
Msg-id 3D1BDEEF.50409@sni.ph
Whole thread Raw
List pgsql-sql
Tree view 
I have a query that returns   ?column?    
-----------------6 days 01:56:14
(1 row)


How can I get it as total number of hours?
Instead of days and hours, I need hours only (all in all, so 24hours * 6 
days + 01:56:14)
Can you help me please? Thanks

pgsql-sql by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Slow SELECT -> Growing Database
Next
From: Tom Lane
Date:
Subject: Re: 2 Selects 1 is faster, why?