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