DATETIME should be an alias for TIMESTAMP, now databend TIMESTAMP is an alias for DATETIME.

[BohuTANG]

DATETIME should be an alias for TIMESTAMP, now databend TIMESTAMP is an alias for DATETIME.

mysql> create table t2(a timestamp);
Query OK, 0 rows affected (0.07 sec)
Read 0 rows, 0 B in 0.019 sec., 0 rows/sec., 0 B/sec.

mysql> desc t2;
+-------+-------------+------+---------+-------+
| Field | Type        | Null | Default | Extra |
+-------+-------------+------+---------+-------+
| a     | DATETIME(6) | NO   | 0       |       |
+-------+-------------+------+---------+-------+

See:
https://docs.snowflake.com/en/sql-reference/data-types-datetime.html#datetime
https://duckdb.org/docs/sql/data_types/timestamp
https://www.cockroachlabs.com/docs/stable/timestamp.html (CRDB has no DATETIME type)

cc @Veeupup @sundy-li

Originally posted by @BohuTANG in #4997 (comment)