Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
While exploring the new function FORMAT I have come across the following issue, would like to know if any one else has faced a similar problem and found the fix for this, or if it is a bug?
SELECT FORMAT(GETDATE(),'mm/dd/yyyy','en-US');
SELECT GETDATE();
Output:
The Format function argument is a .net format string, where mm is minutes and MM is months. You specified minutes, so minutes is what you got.
There are example format strings at Standard Date and Time Format Strings. As an alternative to MM/dd/yyyy you can also use just d which is the Short Date Format specifier (detailed on the linked page).
The FORMAT function is case sensitive
As such, "mm" stands for minutes and "MM" stands for month.
You can see a complete table of combinations and letter meanings here. This is the .NET article for date and time formatting, which SQL Server's FORMAT is using.
