title: How to cast date Strings to DateTime format with extended parsing in ClickHouse?
body: <p>I have a String field with timestamp like this: "2020-01-13T07:34:25.804445Z". And i want to parse it to datetime (to use in Grafana filters, for example). But i getting this error:</p>
  
  <pre><code>SELECT SELECT "@timestamp" AS timestamp, CAST(timestamp AS DateTime) as datetime from table
  
  Cannot parse string '2020-01-13T06:55:05.704Z' as DateTime: syntax error at position 19 (parsed just '2020-01-13T06:55:05').
  </code></pre>
  
  <p>I found variable <a href="https://clickhouse.yandex/docs/en/operations/settings/settings/#settings-date_time_input_format" rel="noreferrer">date_time_input_format on documentation</a> which "allows extended parsing". But it says that this setting doesn't apply to date and time functions. So how do i cast string date with timezone to DateTime?</p>