As I said many times before SQL Server does not stop amazing me continuously. It does not matter how many questions and issues I have come across so far there are always new things to learn. 205 more words
Tags » SQL DateTime
Question: What is the difference between @@DATEFIRST and SET DATEFIRST with respect to SQL Server?
Answer: SQL Server with US English as default language, SQL Server sets DATEFIRST to 7 (Sunday) by default. 110 more words
In the recent past, I have been bringing few puzzles around using date and time functions. All these have brought some awesome feedbacks and you all have been sharing some awesome answers. 302 more words
Playing around with date and time datatypes can be loads of fun. I hope you got the pun intended when I say it is fun. Most of the developers working with date and time datatypes feel it is a pain. 476 more words