Clickhouse: Different behavior of functions toDateTime & toDateTime64

[millin]

Describe the bug
Functions toDateTime & toDateTime64 give a different result.

How to reproduce
ClickHouse server version 20.3.3 revision 54433.

SELECT timezone()

┌─timezone()────┐
│ Europe/Moscow │
└───────────────┘

SELECT toDateTime(today(), 'UTC')                                                                                                                                                                                                                    

┌─toDateTime(today(), 'UTC')─┐                                                                                                                                                                                                                       
│        2020-03-20 00:00:00 │                                                                                                                                                                                                                       
└────────────────────────────┘

SELECT toDateTime64(today(), 0, 'UTC')                                                                                                                                                                                                               

┌─toDateTime64(today(), 0, 'UTC')─┐                                                                                                                                                                                                                  
│             2020-03-19 21:00:00 │                                                                                                                                                                                                                  
└─────────────────────────────────┘

СС @Enmk

[Enmk]

Will make sure it is fixed with https://github.com/ClickHouse/ClickHouse/pull/9574

[Enmk]

Will make sure it is fixed with #9574

Ooops, the issue is still there and requires separate fix.