How hard is LeetCode 1853. Convert Date Format?

LeetCode 1853. Convert Date Format is rated Easy on LeetCode.

What topics does LeetCode 1853. Convert Date Format cover?

LeetCode 1853. Convert Date Format is tagged Database on LeetCode.

Is LeetCode 1853. Convert Date Format a premium problem?

Yes. LeetCode 1853. Convert Date Format is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.

Convert Date Format — LeetCode 1853 Python Solution

EasyLeetCode PremiumDatabase

Problem: #1853
Reading time: 2 min
Source: leetcode.com

Table schema

SQL

Table: Days +-------------+------+ | Column Name | Type | +-------------+------+ | day | date | +-------------+------+ day is the column with unique values for this table. Write a solution to convert each date in Days into a string formatted as "day_name, month_name day, year".

Example

SQL

+-------------+------+
| Column Name | Type |
+-------------+------+
| day         | date |
+-------------+------+
day is the column with unique values for this table.

Python solution

Python

import duckdb
import pandas as pd

def solution(days: pd.DataFrame) -> pd.DataFrame:
    con = duckdb.connect()
    con.register("Days", days)
    return con.execute("""SELECT DATE_FORMAT(day, '%W, %M %e, %Y') AS day FROM Days;""").df()

Complexity

Measure	Complexity
Time	O(n log n) (typical)
Space	O(n) auxiliary

Frequently asked questions

How hard is LeetCode 1853. Convert Date Format?: LeetCode 1853. Convert Date Format is rated Easy on LeetCode.
What topics does LeetCode 1853. Convert Date Format cover?: LeetCode 1853. Convert Date Format is tagged Database on LeetCode.
Is LeetCode 1853. Convert Date Format a premium problem?: Yes. LeetCode 1853. Convert Date Format is a LeetCode Premium problem, so the full statement and test cases require a paid LeetCode subscription.