Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

parsedatetime_* session settings

These settings are available in system.settings and are autogenerated from source.

parsedatetime_e_requires_space_padding

Type
Bool
Default
0
Version history
VersionDefault valueComment
25.50Improved compatibility with MySQL DATE_FORMAT/STR_TO_DATE

Formatter ‘%e’ in function ‘parseDateTime’ expects that single-digit days are space-padded, e.g., ’ 2’ is accepted but ‘2’ raises an error.

parsedatetime_parse_without_leading_zeros

Type
Bool
Default
1
Version history
VersionDefault valueComment
23.111Improved compatibility with MySQL DATE_FORMAT/STR_TO_DATE

Formatters ‘%c’, ‘%l’ and ‘%k’ in function ‘parseDateTime’ parse months and hours without leading zeros.

Navigation