Timeline for Time difference is not returning the expected result in PostgreSQL
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 1, 2022 at 23:52 | comment | added | ypercubeᵀᴹ |
Try for example: select '06:00:00'::TIME, '06:00:00'::TIME + interval '24 hour', '06:00:00'::TIME - interval '24 hour' ;. You'll get three identical values.
|
|
| Apr 1, 2022 at 23:51 | comment | added | ypercubeᵀᴹ |
Yo u are substracting from a time value ('06:00:00') an interval (the result of ('19:00:00'::TIME - '07:00:23.388471'::TIME)). The result of time - interval is a time value. And time values are only between '00:00:00' and '24:00:00'
|
|
| Apr 1, 2022 at 22:53 | history | asked | Ουιλιαμ Αρκευα | CC BY-SA 4.0 |