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:

```sql
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.

Question

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:

```sql
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.

Knowee AI · Accepted Answer

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:

```sql
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.

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

Question

Solution

Similar Questions

Upgrade your grade with Knowee