This puzzle, I have discovered accidentally. In one of the recent project, I had to display two dates next to each other. Now, when I was doing this, I accidentally did a mistake while I was typing that out. Indeed, this puzzle about strange results when adding two dates.
Recently I received a simple question about AT TIME ZONE feature. This is the new feature which is introduced in SQL Server 2016 and later version of the SQL Server. As this is a relatively new feature the adoption of this feature is also a bit slow. However, let us understand how this function really works in a few simple words.
A very strange question I received the other day in an email about how to convert decimal to time format string.
Question: What is the Biggest Limitation of ISDATE() Function?
One of the T-SQL functions introduced in SQL Server 2016 is DATEDIFF_BIG function.
Question: How to Count Week Days Between Two Dates?
In versions prior to 2012, you need to use the CONVERT function with different styles to convert the date values into a different format. Let us learn about the FORMAT function in this blog post.