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.
SQL SERVER – Convert Decimal to Time Format in String
A very strange question I received the other day in an email about how to convert decimal to time format string.
What is the Biggest Limitation of ISDATE() Function? – Interview Question of the Week #137
Question: What is the Biggest Limitation of ISDATE() Function?
SQL SERVER – Learning DATEDIFF_BIG Function in SQL Server 2016
One of the T-SQL functions introduced in SQL Server 2016 is DATEDIFF_BIG function.
How to Count Week Days Between Two Dates? – Interview Question of the Week #132
Question: How to Count Week Days Between Two Dates?
SQL SERVER – Learning New Multipurpose FORMAT Function
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.
SQL SERVER – Alternate to AGENT_DATETIME Function
Sometimes back I posted about interesting function AGENT_DATETIME functions which will convert integers into datetime values. Someone commented that there might be some permission issues using this function which is only available in msdb database. So I write this post to give you alternate method without using any such functions.