Skip to main content
These settings are autogenerated from source.

​
date_time_64_output_format_cut_trailing_zeros_align_to_groups_of_thousands

Dynamically trim the trailing zeros of datetime64 values to adjust the output scale to [0, 3, 6], corresponding to ‘seconds’, ‘milliseconds’, and ‘microseconds’

​
date_time_input_format

Allows choosing a parser of the text representation of date and time. The setting does not apply to date and time functions. Possible values:
  • 'best_effort' — Enables extended parsing. ClickHouse can parse the basic YYYY-MM-DD HH:MM:SS format and all ISO 8601 date and time formats. For example, '2018-06-08T01:02:03.000Z'.
  • 'best_effort_us' — Similar to best_effort (see the difference in parseDateTimeBestEffortUS
  • 'basic' — Use basic parser. ClickHouse can parse only the basic YYYY-MM-DD HH:MM:SS or YYYY-MM-DD format. For example, 2019-08-20 10:18:56 or 2019-08-20.
See also:

​
date_time_output_format

Allows choosing different output formats of the text representation of date and time. Possible values:
  • simple - Simple output format. ClickHouse output date and time YYYY-MM-DD hh:mm:ss format. For example, 2019-08-20 10:18:56. The calculation is performed according to the data type’s time zone (if present) or server time zone.
  • iso - ISO output format. ClickHouse output date and time in ISO 8601 YYYY-MM-DDThh:mm:ssZ format. For example, 2019-08-20T10:18:56Z. Note that output is in UTC (Z means UTC).
  • unix_timestamp - Unix timestamp output format. ClickHouse output date and time in Unix timestamp format. For example 1566285536.
See also:

​
date_time_overflow_behavior

Defines the behavior when Date, Date32, DateTime, DateTime64 or integers are converted into Date, Date32, DateTime or DateTime64 but the value cannot be represented in the result type. Possible values:
  • ignore — Silently ignore overflows. Result are undefined.
  • throw — Throw an exception in case of overflow.
  • saturate — Saturate the result. If the value is smaller than the smallest value that can be represented by the target type, the result is chosen as the smallest representable value. If the value is bigger than the largest value that can be represented by the target type, the result is chosen as the largest representable value.
Default value: ignore.
Last modified on July 23, 2026