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

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to store in hours:minutes:seconds where hours may be bigger than 24
Date: 2024-03-20 02:34:06
Message-ID: CANzqJaA8wrq9QrbskpByq-Gna=fiJD7ma1zE+ddvHhcrquY7Dw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Mar 19, 2024 at 10:05 PM Celia McInnis <celia(dot)mcinnis(at)gmail(dot)com>
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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Baldwin 2024-03-20 02:44:13 Re: How to store in hours:minutes:seconds where hours may be bigger than 24
Previous Message Celia McInnis 2024-03-20 02:05:16 How to store in hours:minutes:seconds where hours may be bigger than 24