Can ClickHouse convert the string in format 'DD-MMM-YYYY' to Date?

user_16238951 0
Viewed 1829

Is there a function like that in clickhouse? Similar to mysql's STR_TO_DATE function.

I need to convert '04-Jun-2021' to '2021-06-04'

clickhouse
1 Answers

Consider using parseDateTime32BestEffort:

SELECT
    '04-Jun-2021' AS str,
    parseDateTime32BestEffort(str) AS dateTime,
    toDate(dateTime) AS date

┌─str─────────┬────────────dateTime─┬───────date─┐
│ 04-Jun-2021 │ 2021-06-04 00:00:00 │ 2021-06-04 │
└─────────────┴─────────────────────┴────────────┘
user_3032980
Related