Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

formatdatetime_f_* session settings

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

formatdatetime_f_prints_scale_number_of_digits

Type
Bool
Default
0
Version history
VersionDefault valueComment
25.10New setting.

Formatter ‘%f’ in function ‘formatDateTime’ prints only the scale amount of digits for a DateTime64 instead of fixed 6 digits.

formatdatetime_f_prints_single_zero

Type
Bool
Default
0
Version history
VersionDefault valueComment
23.40Improved compatibility with MySQL DATE_FORMAT()/STR_TO_DATE()

Formatter ‘%f’ in function ‘formatDateTime’ prints a single zero instead of six zeros if the formatted value has no fractional seconds.

Navigation