Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Postgresql max time value

In the postgresql documentation related to date/time types. It is stated that the type time can have a max value of 24:00:00. Can someone could explain to me the purpose of settings this value to this instead of 23:59:59 ? There’s maybe a reason for this but i just don’t get it.

https://www.postgresql.org/docs/current/datatype-datetime.html

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

>Solution :

When there is a leap second the traditional way of representing that is 23:59:60 but it looks like PostgreSQL chose to handle it with the hour 24.

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading