Easy way to retrive timestamp from SQL Server db

Question

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?

John Saunders · Accepted Answer · 2009-12-05 01:20:06Z

5

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.

edited Dec 5, 2009 at 1:20

John Saunders

162k26 gold badges252 silver badges403 bronze badges

answered Apr 11, 2009 at 11:32

Erik

4,1052 gold badges30 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user84026 Over a year ago

Could be usefull then with a solution on how to change the MSSQL DB to cope with timestamps like MsSQL

Erik Over a year ago

You define your own DATETIME-field, and remember to update this field whenever you change the content of the row. This is done automatically with MSSQL timestamp field.

Collectives™ on Stack Overflow

Easy way to retrive timestamp from SQL Server db

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related