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:43:59
Message-ID: CADp-Sm5VJ=H+mjYJKgv8boogLyFi-wUW8CiAMzQxrTbS94S-KA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sun, Jan 5, 2014 at 10:37 PM, Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>wrote:

> 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
>

Refer to this documentation:
http://www.postgresql.org/docs/9.3/static/datatype-datetime.html

> > thank you.
> >
>

Regards
Sameer

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Magnus Persson 2014-01-05 16:28:41 Re: Returning NULL from SRF
Previous Message Magnus Persson 2014-01-05 14:40:27 Returning NULL from SRF