00:00:00

Description

Editorial

Calendar Date Long-Format Renderer

EASY10 pts

An analytics reporting layer stores daily partitions in ISO date form and needs a presentation-ready version for business-facing exports.

Table: days

day: a unique calendar date

Task: Transform each row into this exact string layout:

WeekdayName, MonthName DayNumber, Year

Examples of valid output values:

Tuesday, April 12, 2022
Monday, August 9, 2021

Output requirements:

Return exactly one column:
- day
Keep exact English spelling, capitalization, spaces, and commas.
Row order may be returned in any order.

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

days:
| day        |
|------------|
| 2022-04-12 |
| 2021-08-09 |
| 2020-06-26 |

Output

[
  {"day":"Tuesday, April 12, 2022"},
  {"day":"Monday, August 9, 2021"},
  {"day":"Friday, June 26, 2020"}
]

Explanation

Each source date is rendered as weekday name, month name, day number without leading zero, and four-digit year.

Example

Input

days:
| day        |
|------------|
| 2000-02-29 |
| 2100-03-01 |
| 1970-01-01 |

Output

[
  {"day":"Tuesday, February 29, 2000"},
  {"day":"Monday, March 1, 2100"},
  {"day":"Thursday, January 1, 1970"}
]

Explanation

Leap-year and boundary-era dates must still follow identical formatting rules.

Example

Input

days:
| day        |
|------------|
| 2024-11-03 |
| 2024-11-30 |
| 2024-12-01 |

Output

[
  {"day":"Sunday, November 3, 2024"},
  {"day":"Saturday, November 30, 2024"},
  {"day":"Sunday, December 1, 2024"}
]

Explanation

Single-digit and double-digit day numbers are both supported; only the day number formatting differs.

Accepted0/0·0% Acceptance

Constraints

0 <= number of rows in days <= 5000
1970-01-01 <= day <= 2100-12-31
day is unique within the table
Return exactly one column named day
Output text is case-sensitive and punctuation-sensitive
Rows may be returned in any order
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with exactly one column: day

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

days =

[{"day":"2022-04-12"},{"day":"2021-08-09"},{"day":"2020-06-26"}]

Loading problem...

101

00:00:00

Description

Editorial

Calendar Date Long-Format Renderer

EASY10 pts

An analytics reporting layer stores daily partitions in ISO date form and needs a presentation-ready version for business-facing exports.

Table: days

day: a unique calendar date

Task: Transform each row into this exact string layout:

WeekdayName, MonthName DayNumber, Year

Examples of valid output values:

Tuesday, April 12, 2022
Monday, August 9, 2021

Output requirements:

Return exactly one column:
- day
Keep exact English spelling, capitalization, spaces, and commas.
Row order may be returned in any order.

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

days:
| day        |
|------------|
| 2022-04-12 |
| 2021-08-09 |
| 2020-06-26 |

Output

[
  {"day":"Tuesday, April 12, 2022"},
  {"day":"Monday, August 9, 2021"},
  {"day":"Friday, June 26, 2020"}
]

Explanation

Each source date is rendered as weekday name, month name, day number without leading zero, and four-digit year.

Example

Input

days:
| day        |
|------------|
| 2000-02-29 |
| 2100-03-01 |
| 1970-01-01 |

Output

[
  {"day":"Tuesday, February 29, 2000"},
  {"day":"Monday, March 1, 2100"},
  {"day":"Thursday, January 1, 1970"}
]

Explanation

Leap-year and boundary-era dates must still follow identical formatting rules.

Example

Input

days:
| day        |
|------------|
| 2024-11-03 |
| 2024-11-30 |
| 2024-12-01 |

Output

[
  {"day":"Sunday, November 3, 2024"},
  {"day":"Saturday, November 30, 2024"},
  {"day":"Sunday, December 1, 2024"}
]

Explanation

Single-digit and double-digit day numbers are both supported; only the day number formatting differs.

Accepted0/0·0% Acceptance

Constraints

0 <= number of rows in days <= 5000
1970-01-01 <= day <= 2100-12-31
day is unique within the table
Return exactly one column named day
Output text is case-sensitive and punctuation-sensitive
Rows may be returned in any order
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with exactly one column: day

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

days =

[{"day":"2022-04-12"},{"day":"2021-08-09"},{"day":"2020-06-26"}]

Calendar Date Long-Format Renderer

Hints

Calendar Date Long-Format Renderer

Hints