页次: 1
首先要熟悉一下mysql中的时间类型
其他的类型 mysql的数据类型
year -- 1901-2155(一个字节)
date -- "1000-01-01" - " 9999-12-31" (四个字节)
time -- "-838:59:58" - "-838:59:58" (三个字节)
datetime -- "1000-01-01 00:00:00——9999-12-31 23:59:59" (八个字节")
timestamp -- 时间截 4个字节
常用 now(), year(), month(), day(), hour(), minute(), second(); dayofweek();
mysql> select now(); +---------------------+ | now() | +---------------------+ | 2014-11-07 11:23:49 | +---------------------+ 1 row in set (0.02 sec) mysql> select year(now()); +-------------+ | year(now()) | +-------------+ | 2014 | +-------------+ 1 row in set (0.00 sec) mysql> select dayofweek(now()); +------------------+ | dayofweek(now()) | +------------------+ | 6 | +------------------+ 1 row in set (0.00 sec)
获得时间
mysql> select time(now()); +-------------+ | time(now()) | +-------------+ | 11:25:05 | +-------------+
获得时间 也可以用
select curtime();
同理
select curdate(); select date(now());
获得日期差
mysql> select datediff(now(), adddate(now() , -1)); +--------------------------------------+ | datediff(now(), adddate(now() , -1)) | +--------------------------------------+ | 1 | +--------------------------------------+ 1 row in set (0.02 sec)
ipbbs.net
离线
页次: 1