You would like to display the system date in the format "Monday, 01 June, 21". Which SELECT statement should you use?

In SQL, you can use the GETDATE() function to get the current date and time. However, to format it in the way you want, you can use the FORMAT() function. Here is the SQL statement you should use:

SELECT FORMAT ( GETDATE(), 'dddd, dd MMMM, yy' ) as Date;

Here's what it does:

• GETDATE() gets the current date and time.
• FORMAT() is a function that formats the date and time in a specified format.
• 'dddd, dd MMMM, yy' is the format string. dddd represents the full name of the day of the week, dd represents the day of the month as a number, MMMM represents the full name of the month, and yy represents the year as a two-digit number.
• as Date gives the column a name.