MariaDB [test]> CREATE OR REPLACE VIEW v1 AS SELECT timestamp'2001-01-01 10:10:10' AS c1, now() AS c2;
|
Query OK, 0 rows affected (0.001 sec)
|
|
MariaDB [test]> SHOW COLUMNS IN v1;
|
+-------+----------+------+-----+---------------------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+----------+------+-----+---------------------+-------+
|
| c1 | datetime | NO | | 0000-00-00 00:00:00 | |
|
| c2 | datetime | NO | | 0000-00-00 00:00:00 | |
|
+-------+----------+------+-----+---------------------+-------+
|