🚀

End of Year Sale: Use Coupon Code END2025 to Get Extra 25% Off.

07DAYS

:

18HOURS

:

17MINUTES

:

23SECONDS

Leetcode Problem 1853. Convert Date Format

1853. Convert Date Format

Leetcode Solutions

Using DATE_FORMAT Function

Use the DATE_FORMAT function to format the day column in the Days table.
Use the format string '%W, %M %e, %Y' to get the day name, month name, day of the month, and year in the desired format.
Alias the result of the DATE_FORMAT function as day to match the output column name.
Select the formatted day from the Days table.


erDiagram
    Days {
        date day PK
    }

Using CONCAT and Date Functions

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Loading...

Suggested Answer

Answer

Full Screen

Copy Answer Code

Loading...