Is there a way to convert TimeStamp to DateTime?
-
Hi Guys, Is there a solution on how to convert TimeStamp to DateTime? Thanks
hifiger2004
-
Hi Guys, Is there a solution on how to convert TimeStamp to DateTime? Thanks
hifiger2004
Why isn't this in the SQL/database forum? To quote from SQL Server Books Online: "The SQL Server timestamp data type has nothing to do with times or dates. SQL Server timestamps are binary numbers that indicate the relative sequence in which data modifications took place in a database. The timestamp data type was originally implemented to support the SQL Server recovery algorithms. Never use timestamp columns in keys, especially primary keys, because the timestamp value changes every time the row is modified."
-
Why isn't this in the SQL/database forum? To quote from SQL Server Books Online: "The SQL Server timestamp data type has nothing to do with times or dates. SQL Server timestamps are binary numbers that indicate the relative sequence in which data modifications took place in a database. The timestamp data type was originally implemented to support the SQL Server recovery algorithms. Never use timestamp columns in keys, especially primary keys, because the timestamp value changes every time the row is modified."
Yes, I actually read the mssql help file and it says that its the same as the rowversion. Microsoft shouldn't named it to timestamp. It could be something like "rowstampid" or something. Because in Oracle the timestamp can be converted to datetime. Anyway, thanks for the answer.
hifiger2004