cast_string_* session settings

These settings are available in system.settings and are autogenerated from the ClickHouse snapshot.

cast_string_to_date_time_mode

Allows choosing a parser of the text representation of date and time during cast from String.

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:

• DateTime data type.
• Functions for working with dates and times.

cast_string_to_dynamic_use_inference

Use types inference during String to Dynamic conversion

cast_string_to_variant_use_inference

Use types inference during String to Variant conversion.