When formatting a date using the FORMAT()
function in SQL Server, the date will be formatted according to the language of your local session. However, you can override this by specifying a culture to use, or using a custom date format.
This article demonstrates how to explicitly specify a German date format by using the optional “culture” argument of the FORMAT()
function. It also demonstrates how to use your own custom date format if that is more desirable.