Tim Skauge
Reputation: 1844
Easy way to retrive timestamp from SQL Server db
I have a timestamp column (updated) in my Microsoft Sql Server Database and wish to retrieve the value as a DateTime object using SqlConnection and SqlCommand.
What is the easiest way to do this?
Upvotes: 0
Views: 492
Answers (1)
Erik
Reputation: 4105
A timestamp field in a SQL Server database is not related to the date and time, but is merely a sequence number.
A timestamp in MySql is on the other hand a datetime-value.
Upvotes: 5
Related Questions
- How to retrieve Timestamp value from SQL Server using DataReader
- How to get timestamp with milliseconds while retrieving from SQL Server?
- How to read timestamp type's data from sql server using C#?
- Convert from DateTime to TimeStamp
- Pass timestamp to sql server where clause
- SQL Request with Timestamp
- SQL Server Timestamp using with C#
- How can I store/retrieve a timestamp in SQL Server?
- Get DateTime from SQL database
- C# Getting Just Date From Timestamp