MySQL中的时态(日期/时间)数据类型

时间:2025-03-30 15:06:43

时态类型的取值范围

MySQL中的时态(日期/时间)数据类型

 mysql> create table t (dt datetime,d date,t time);
Query OK, 0 rows affected (0.30 sec) mysql> insert into t (dt,d,t) values (now(),now(),now());
Query OK, 1 row affected, 1 warning (0.08 sec) mysql> select * from t;
+---------------------+------------+----------+
| dt | d | t |
+---------------------+------------+----------+
| 2017-12-20 21:39:42 | 2017-12-20 | 21:39:42 |
+---------------------+------------+----------+
1 row in set (0.00 sec)