search

timeplus-io / proton

A stream processing engine and database, and a fast and lightweight alternative to ksqlDB and Apache Flink, 🚀 powered by ClickHouse
https://timeplus.com
Apache License 2.0
1.58k stars 69 forks source link

Serialization error existed in to_datetime64 function #843

Closed Jasmine-ge closed 3 weeks ago

Jasmine-ge commented 4 weeks ago

Error will occur if we add time zone fraction in to_datetime64 function

timeplus-OptiPlex-7000 :) select to_datetime64('2022-12-30 13:44:17.00+08:00',2)

SELECT
  to_datetime64('2022-12-30 13:44:17.00+08:00', 2)

Query id: 27f6935a-8deb-4ece-a4d1-4339203048fe

0 rows in set. Elapsed: 220.572 sec. 

Received exception from server (version 1.6.1):
Code: 6. DB::Exception: Received from localhost:8463. DB::Exception: Cannot parse string '2022-12-30 13:44:17.00+08:00' as datetime64(2): syntax error at position 22 (parsed just '2022-12-30 13:44:17.00'). (CANNOT_PARSE_TEXT)