Details
-
Sub-task
-
Status: Open
-
Major
-
Resolution: Unresolved
-
3.1.0
-
None
-
None
Description
PostgreSQL allows to specify interval precision, see https://www.postgresql.org/docs/12/datatype-datetime.html
| interval [ {{fields ] [ (p) ]}} | 16 bytes | time interval | -178000000 years | 178000000 years | 1 microsecond |
For example:
maxim=# SELECT interval '1 2:03.4567' day to second(2);
interval
-------------------
1 day 00:02:03.46
(1 row)