- What is the best TIMESTAMP format?
- Can timestamps be altered?
- What are the different TIMESTAMP formats?
What is the best TIMESTAMP format?
We at Moesif prefer ISO 8601 ( yyyy-MM-dd'T'HH:mm:ssZ ) because it's human readable and has a specified timezone. There is no ambiguity if the epoch is in seconds or milliseconds. ISO 8601 strings are encoded in a way that enable decent string sorting and comparison. Epoch has benefits over ISO 8601 also.
Can timestamps be altered?
Yes, the POSIX system calls utime() and utimensat() can change the timestamp of any file to which you have permissions, and for which you have written a program to do so. And, the system time of any computer would have to be corroborated by other evidence for the period in question.
What are the different TIMESTAMP formats?
With the fractional part included, the format for these values is ' YYYY-MM-DD hh:mm:ss [. fraction ]' , the range for DATETIME values is '1000-01-01 00:00:00.000000' to '9999-12-31 23:59:59.999999' , and the range for TIMESTAMP values is '1970-01-01 00:00:01.000000' to '2038-01-19 03:14:07.999999' .