In what format is it better to store the value in the database?

Question

PHP

What is the best way to store time duration in DB?
Well, for example, there is a process and this process has a runtime equal to 10 minutes, in what form is it better to give these 10 minutes to the database? The duration may be a few seconds, or it may be several years.
postgresql database.

Answer 1

There is an interval data type - use it. As the documentation suggests , its accuracy is up to one microsecond, and the range of values ​​... in general, is enough for you.

Answer 2

Maybe I will say sedition, but I would store 2 timestamp (beginning and end). 8 bytes per field, equivalent to one 16-byte Interval (I suspect that it has the same logic in its giblets).