mysql中时间处理函数_MySQL中时间处理函数

1,date和datetime类型的区别date 类型 存储2009-01-12这样的字样，及只存储日期类型datetime 类型 存储’2009-06-02 17:10:00‘ ，及存储日期时间类型2,将秒转为时间mysql> select from_unixtime(1246412182);+---------------------------+| from_unixtime(1246412182) |+---------------------------+| 2009-07-01 09:36:22 |+---------------------------+3，将时间转为秒数mysql> SELECT UNIX_TIMESTAMP('2009-07-01 09:40:22');+---------------------------------------+| UNIX_TIMESTAMP('2009-07-01 09:40:22') |+---------------------------------------+| 1246412422 |+---------------------------------------+4，获取当前的系统秒数mysql> select UNIX_TIMESTAMP();+------------------+| UNIX_TIMESTAMP() |+------------------+| 1246412366 |+------------------+5，获取系统当前的时间值mysql> select CURRENT_TIMESTAMP();+---------------------+| CURRENT_TIMESTAMP() |+---------------------+| 2009-07-01 09:40:22 |+---------------------+6,判断两个日期时间的相差的天数:第一个参数大时间，后一个小时间select DATEDIFF(CURRENT_TIMESTAMP(),'2009-06-02 17:10:00');7，取得指定日期时间值中的日期mysql> select time('2009-07-27 23:59:59');+-----------------------------+| time('2009-07-27 23:59:59') |+-----------------------------+| 23:59:59 |+-----------------------------+1 row in set (0.00 sec)mysql> select date('2009-07-27 23:59:59');+-----------------------------+| date('2009-07-27 23:59:59') |+-----------------------------+| 2009-07-27 |+-----------------------------+1 row in set (0.00 sec)mysql> SELECT DATE_FORMAT('1997-01-04', '%Y%m');+-----------------------------------+| DATE_FORMAT('1997-01-04', '%Y%m') |+-----------------------------------+| 199701 |+-----------------------------------+1 row in set (0.00 sec)

posted on 2011-01-23 16:52 大龙 阅读(593) 评论(0)  编辑 收藏 引用