Re: total time more than 24 hours

From: Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>
To: avpro avpro <avprowebeden(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: total time more than 24 hours
Date: 2014-01-05 14:37:54
Message-ID: CADp-Sm42MChH2Ae9_G2BtKKam5OvgFVjs5_7uooLYrQ9DnofJg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Regards
Sameer

PS: Sent from my Mobile device. Pls ignore typo n abb
On 5 Jan 2014 22:32, "avpro avpro" <avprowebeden(at)gmail(dot)com> wrote:
>
> hi,
>
> I would like to have a table with one field storing time values greater
than 24 hours.
> for example: 53:42 (53 hrs and 42 min). how could i do this?

Its not 'TIME' but 'TIME INTERVAL' that you want to use. Try interval data
type in postgreSQL

> thank you.
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Magnus Persson 2014-01-05 14:40:27 Returning NULL from SRF
Previous Message avpro avpro 2014-01-05 14:32:17 total time more than 24 hours