Data type: Difference between revisions

Jump to navigation Jump to search
511 bytes added ,  13 June 2013
Line 58: Line 58:
** range/limit:
** range/limit:
</pre>
</pre>
== 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
* MySQL ex: 2013-06-13 03:33:33


== references ==
== references ==
<references />  
<references />


== further reading ==
== further reading ==

Navigation menu