SQL Interview Questions – Convert Date Format

Spread the love

Problem Description –

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.

Problem Link – Date Format

Difficulty Level – Easy

Solution –

SELECT DATE_FORMAT(day, "%W, %M %e, %Y") AS day
FROM Days

Rating: 1 out of 5.

Leave a Reply