How to set the timestamp with microseconds as default value?
- @zenith, do you believe in the correctness of microseconds in modern OS? - avp
- @avp is actually the need for microseconds in the database has already disappeared, after editing the code, but the question itself is interesting. - zenith
|
2 answers
Well, judging by the changelog version 5.6.4, you can ...
bug old and famous
Noted in 5.6.4 changelog.
MySQL now supports fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microsecond precision.
thunder thunder
7.278 9 nineteen
- proof - thunder
|
No MySQL does not support microsecond storage. But you can create your own date-time format.
Indifferent Indifferent
3,097 7 17
|