14,957
edits
Data type: Difference between revisions
Jump to navigation
Jump to search
m
→comparision of datatypes in different data engines
| Line 60: | Line 60: | ||
== comparision of datatypes in different data engines == | == comparision of datatypes in different data engines == | ||
DATETIME: ex: "2013-06-13 03:33:33" MS SQL 2008, MySQL is equivalent | |||
TIMESTAMP: MS SQL 2008 and MySQL is '''NOT''' equivalent<ref>[http://stackoverflow.com/questions/8665548/sql-server-2008-timestamp-data-type SQL Server 2008 timestamp data type - Stack Overflow]</ref> {{exclaim}} | |||
* MS SQL 2008<ref>[http://msdn.microsoft.com/en-us/library/ms182776(v=sql.90).aspx timestamp (Transact-SQL)]</ref> ex: 0x00000000000007D3 | * MS SQL 2008<ref>[http://msdn.microsoft.com/en-us/library/ms182776(v=sql.90).aspx timestamp (Transact-SQL)]</ref> ex: 0x00000000000007D3 | ||
* MySQL ex: 2013-06-13 03:33:33 | * MySQL ex: 2013-06-13 03:33:33 | ||