Running query in clickhouse, select log_time, toYYYYMM(log_time), toYYYYMMDD(log_time) from new_log limit 1 and it outputs '2024-02-29 16:00:00', '202403','20240301'. The date month is Febrary but toYYYYMM gives the March. btw: My timezone is +8.
2024/03/21:
Runs the above select statement in clickhouse-client and it gives different output.
So the problem should be related with client tool dbeaver. Thanks @vladimir for your answer.