> For the complete documentation index, see [llms.txt](https://jaywin.gitbook.io/leetcode/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jaywin.gitbook.io/leetcode/solutions/1853-convert-date-format.md).

# 1853. Convert Date Format

<https://leetcode.com/problems/convert-date-format>

## Description

Table: `Days`

```
+-------------+------+
| Column Name | Type |
+-------------+------+
| day         | date |
+-------------+------+
day is the primary key for this table.
```

Write an SQL query to convert each date in `Days` into a string formatted as `"day_name, month_name day, year"`.

Return the result table **in any order**.

The query result format is in the following example:

```
Days table:
+------------+
| day        |
+------------+
| 2022-04-12 |
| 2021-08-09 |
| 2020-06-26 |
+------------+
Result table:
+-------------------------+
| day                     |
+-------------------------+
| Tuesday, April 12, 2022 |
| Monday, August 9, 2021  |
| Friday, June 26, 2020   |
+-------------------------+
Please note that the output is case-sensitive.
```

## ac

```java
```