Anyone know how to convert the time stamp in the Modified column in the data base? Does not seem to be seconds since 1/1-1970.
Here is an example of a time stamp from the database: 0x00000000076A814A
Here is an example of a time stamp from the database: 0x00000000076A814A
Comments
2 comments
The Transact-SQL timestamp data type is different from the timestamp data type defined in the ISO standard, please consider reading those articles for clarification on your question:
http://stackoverflow.com/questions/7105093/difference-between-datetime-and-timestamp-in-sqlserver
According to the documentation, timestamp is a synonym for rowversion - it's automatically generated and guaranteed to be unique. datetime isn't - it's just a data type which handles dates and times, and can be client-specified on insert etc.
--
https://msdn.microsoft.com/en-us/library/ms182776.aspx
Transact-SQL and ISO differences.
Regards,
Vladislav
Please sign in to leave a comment.