Answer the question
In order to leave comments, you need to log in
Why do PostgreSQL and MySQL date accuracy only to microseconds?
Date storage accuracy in different relational databases is different:
+--------------+-------------------------------+----------------+
| Oracle | 2001-01-01 23:59:59:999999999 | наносекунда |
| MSSQL | 2001-01-01 23:59:59:9999999 | сто наносекунд |
| MySQL | 2001-01-01 23:59:59:999999 | микросекунда |
| PostgreSQL | 2001-01-01 23:59:59:999999 | микросекунда |
+--------------+-------------------------------+----------------+
Answer the question
In order to leave comments, you need to log in
Increased accuracy requires increased resource costs.
For most users, such accuracy is not needed, and if the need arises, then it can be implemented in an alternative way, for example, by storing these extra values in a separate table field.
What prevents MSSQL from maintaining nanosecond date precision
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question