Datetime in sqlserver

[kurangu]

folks, I have a table with column upddate with datatype as datetime. I updated the table update table set upddate=getdate() when i select the values all the upddates are same. I expected difference in milli seconds to find the last updated record. can somebody help me out.

[Neeraj Kr]

Actually, your expectation is not wrong. But the effect can only be seen if there are millions of records. For lesser number of rows, it will reflect the same time.

-----Have A Nice Day-----

[Ashfield]

Simple really, the update happened so quickly they are all the same time. Also be warned, SQL Server is only accurate (from memory) to a third of a millisecond.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

[dan sh]

Ashfield wrote:

SQL Server is only accurate (from memory) to a third of a millisecond.

That's a good information to have. Thanks.

[David Skelly]

Actually, DATETIME in SQL Server is only accurate to about 3 milliseconds. Which is not very accurate at all, in computing terms. There is a new datatype called DATETIME2 in the latest version of SQL Server which is accurate down to nanoseconds. Hundreds of highly trained database experts worked for weeks to come up with that name for the new datatype.

[Ashfield]

I knew 3 and milliseconds came into, just couldn't remember where. I knew about datetime2 in 2008, but didn't realise so much time had been spent deciding on a name :-D

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP