Format Date Time Function

Function do return common datatime formats of a date.
select dbo.[KDT_FN_FORMATDATETIME]('LASTDAY DDDD',getdate())

SQL Server Datetime vs. Datetime2

Read a short comparison of datetime and datetime2 types. Learn about their structure, as well as the advantages and disadvantages of each.

In The Beginning

Datetime Formats

This stored procedure will show all possible datetime formats when used with the style argument in the CONVERT() function. It also shows sample output from the date part arguments.

Datetime conversion of empty string

Function to format a datetime variable by a mask

I have used the following function to convert dates according to desired textual formats that were not immediately available in the standard styles on offer.

DATETIME - 4

DATETIME - 3

DATETIME 2

DATETIME 1