Re: Help needed on time data types

From: Michal Taborsky <michal(at)taborsky(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Help needed on time data types
Date: 2004-07-12 08:22:36
Message-ID: 40F24A4C.8020103@taborsky.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

mike wrote:
> I cannot seem to find a field type in postgres that is equivalent to
> h:mm without enforcing a 24 hour day limit. This seems to preclude pg
> from use - am I correct?

You want to use "interval" data type and then do some formatting on the
output to get 123 hours 30 minutes.

See:
http://www.postgresql.org/docs/7.4/interactive/datatype-datetime.html

--
Michal Taborsky
http://www.taborsky.cz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2004-07-12 08:29:04 Re: Help needed on time data types
Previous Message mike 2004-07-12 07:53:01 Help needed on time data types