MySQL 中的日期类型如何实现写入与查询
发布网友
共1个回答
热心网友
类似于date_format、convert,示例如下：
mysql> select date_format('2010-10-01','%Y-%m-%d');
+--------------------------------------+
| date_format('2010-10-01','%Y-%m-%d') |
+--------------------------------------+
| 2010-10-01 |
+--------------------------------------+
1 row in set (0.00 sec)
mysql> select convert('2010-10-01',datetime);
+--------------------------------+
| convert('2010-10-01',datetime) |
+--------------------------------+
| 2010-10-01 00:00:00 |
+--------------------------------+
1 row in set (0.02 sec)
