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
| Version | Default value | Comment |
|---|---|---|
| 25.1 | 0 | New 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
| Version | Default value | Comment |
|---|---|---|
| 23.4 | 0 | Improved 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.