Postgres Pro
Downloads
Home   >   mailing lists

Re: How to store in hours:minutes:seconds where hours may be bigger than 24 - Mailing list pgsql-general

From Ron Johnson
Subject Re: How to store in hours:minutes:seconds where hours may be bigger than 24
Date
Msg-id CANzqJaA8wrq9QrbskpByq-Gna=fiJD7ma1zE+ddvHhcrquY7Dw@mail.gmail.com
Whole thread Raw
In response to How to store in hours:minutes:seconds where hours may be bigger than 24  (Celia McInnis <celia.mcinnis@gmail.com>)
List pgsql-general
Tree view
On Tue, Mar 19, 2024 at 10:05 PM Celia McInnis <celia.mcinnis@gmail.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. 
 

pgsql-general by date:

Previous
From: Celia McInnis
Date:
Subject: How to store in hours:minutes:seconds where hours may be bigger than 24
Next
From: Steve Baldwin
Date:
Subject: Re: How to store in hours:minutes:seconds where hours may be bigger than 24