Inserting timestamp value in SQL Server

Posted by JPro on Stack Overflow See other posts from Stack Overflow or by JPro
Published on 2010-03-25T18:16:43Z Indexed on 2010/03/25 18:23 UTC
Read the original article Hit count: 126

Filed under:
|
|

I am trying to copy data from my MYSQL table to SQL Server using PHP.

I have a TimeStamp value that needs to be copied. While I am trying to copy the fields, it gave an error that timestamp value cannot be inserted. Is there any way to insert the timestamp value?

Is it is not possible, then declaring the column as nvarchar will insert the timestamp, but will I be able to search the data in a date range?

Can anyone please clarify my doubt?

Thanks.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about mysql