Modern Datatime Addition

Switching the time zone

The Datatimeoffset Value

DateTimeOffSet to Character

Reporting by date - DateTrunc

A function to truncate datetimes to month, quarter, hour etc and their multiples for convenient grouping

The Current Date

Function to Round or Truncate DateTime

This Function is used to round to Second, Minute, Hour or Day or to Truncate to Second, Minute, Hour, Day, Month or Year and return Datetime Value

Change datetime

If you have any requirement to extract next 100 sequential date from a present date, you can use the below script. You can change the @datetimeformat value and the output will appear in the same format.

A SQL Server Date Handling Issue

How do you think SQL Server will handle this scenario ?

It's the end of the year