Should Cast(UTF-8 AS Timestamp) apply local time zone? #3080
Description
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
dataufusion v10.0.0's applies local time zone (i'm in UTC+8)
❯ select cast('2000-01-01T00:00:00' as timestamp);
+------------------------------------------------------------------+
| CAST(Utf8("2000-01-01T00:00:00") AS Timestamp(Nanosecond, None)) |
+------------------------------------------------------------------+
| 1999-12-31 16:00:00 |
+------------------------------------------------------------------+
1 row in set. Query took 0.004 seconds.while postgresql's is not
willy=# select cast('2000-01-01T00:00:00' as timestamp);
timestamp
---------------------
2000-01-01 00:00:00
(1 row)Describe the solution you'd like
A clear and concise description of what you want to happen.
Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.
Additional context
Add any other context or screenshots about the feature request here.