HI,
I want to know if there is any datatype in C# that allows return of timestamp? I'm accessing stored proc that expects a timestamp input parameter. Can anyone help me with this?
Printable View
HI,
I want to know if there is any datatype in C# that allows return of timestamp? I'm accessing stored proc that expects a timestamp input parameter. Can anyone help me with this?
Can you be more specific with your question? Have you tried the plain DateTime data type?
A timestamp as in SQL timestamp? For your knowledge "timestamp" is the same as varbinary(8), just except for the automatic update behavior.
The timestamp in SQL Server maps to a Byte[] type in .NET framework. byte[] - i.e. an array of bytes. It is not used as DateTime. If you just need to store date/time information, try to use datetime data type, it maps to a DateTime object in .NET framework. The SQL TimeStamp is fully based on insert / update order on your sql server.
Refer to following links , see if they helps you:
http://msdn.microsoft.com/en-us/library/ms182776.aspx
http://msdn.microsoft.com/en-us/libr...8VS.71%29.aspx
Hope this will hep.