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.
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.