一个时间转换的小问题

Question

datatime类型时间2009-06-08 12:23:43用哪个数据库函数能取得
2009-06-08 这个日期值和
12:23:43   这个时间值而且能和日期或时间字符串"xxxx-xx-xx"或"xx:xx:xx"做比较我的目的就是从数据库取个日期值,然后判断下是不是当天的日期(年月日),(时分秒忽略)由于时间紧些,所以直接来问问,否则就自己搜索了

Answer 1

mysql> select date('2009-06-08 12:23:43'),time('2009-06-08 12:23:43');
+-----------------------------+-----------------------------+
| date('2009-06-08 12:23:43') | time('2009-06-08 12:23:43') |
+-----------------------------+-----------------------------+
| 2009-06-08                  | 12:23:43                    |
+-----------------------------+-----------------------------+
1 row in set (0.00 sec)mysql>

Answer 2

SELECT DATE('2009-06-08 12:23:43'),TIME('2009-06-08 12:23:43')

Answer 3

而且能和日期或时间字符串"xxxx-xx-xx"或"xx:xx:xx"做比较mysql> select date('2009-06-08 12:23:43')='2009-06-08';
+------------------------------------------+
| date('2009-06-08 12:23:43')='2009-06-08' |
+------------------------------------------+
|                                        1 |
+------------------------------------------+
1 row in set (0.00 sec)mysql> select time('2009-06-08 12:23:43')='12:23:43';
+----------------------------------------+
| time('2009-06-08 12:23:43')='12:23:43' |
+----------------------------------------+
|                                      1 |
+----------------------------------------+
1 row in set (0.05 sec)mysql>