Search Postgresql Archives

Re: How to store in hours:minutes:seconds where hours may be bigger than 24

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: How to store in hours:minutes:seconds where hours may be bigger than 24
From: Ron Johnson <ronljohnsonjr@xxxxxxxxx>
Date: Tue, 19 Mar 2024 22:34:06 -0400
In-reply-to: <CAGD6t7JzcmpQ2m5exP=jN6frCs4uVW80KWiuBuginq6mO3oRRw@mail.gmail.com>
References: <CAGD6t7JzcmpQ2m5exP=jN6frCs4uVW80KWiuBuginq6mO3oRRw@mail.gmail.com>

On Tue, Mar 19, 2024 at 10:05 PM Celia McInnis <celia.mcinnis@xxxxxxxxx> wrote:

Hi:

I want to store times in a database as hours:minutes:seconds where hours can be greater than 24. How do I do this? I will want to be able to add such times.

Try the INTERVAL data type.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- How to store in hours:minutes:seconds where hours may be bigger than 24
  - From: Celia McInnis

Prev by Date: How to store in hours:minutes:seconds where hours may be bigger than 24
Next by Date: Re: How to store in hours:minutes:seconds where hours may be bigger than 24
Previous by thread: How to store in hours:minutes:seconds where hours may be bigger than 24
Next by thread: Re: How to store in hours:minutes:seconds where hours may be bigger than 24
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux