SQL Server Code,Tips and Tricks, Performance Tuning
A blog about SQL Server, Books, Movies and life in general
Showing posts with label
Datetime
.
Show all posts
Showing posts with label
Datetime
.
Show all posts
Wednesday, October 10, 2007
SQL Teaser: Guess the output
›
What do you think will be the output? DECLARE @d datetime SET @d = '20071010' SELECT DATEADD (yy, DATEDIFF (yy, 0, @d)+1, -1) Aft...
2 comments:
Wednesday, August 01, 2007
SQL Server 2008 Has Nanosecond Precision?
›
It looks like SQL Server 2008 has nanosecond + microseconds precision for the time datatype If you run the following [edit]I just looked at ...
Friday, July 13, 2007
Summer SQL Teaser Datetime Yet Again
›
Okay one more quick teaser You have this date '2007-01-01 00:00:00.001' When adding 1 or 2 milliseconds to that date what will be th...
›
Home
View web version