MySQL: 日期函数

select current_date() from dual;
select current_time() from dual;
select current_timestamp() from dual;
select date_add(now,interval 10 minute) from dual;
select * from table where date > date_sub(now(),interval 10 day);
select datediff(date1,date2);
select timediff(time1,time2);
select datediff(now(),'1995-1-1') from dual;  # 1995-1-1至今天的天数
select datediff('2005-2-5','2005-2-8') from dual;  # 两个日期相隔天数
select datediff(date_add('1995-2-5',interval 80 year),now()) from dual;  # 1995-2-5 80年后距离今天天数
select year(now()) from dual;
select month(now()) from dual;
select day(now()) from dual;
select hour(now()) from dual;
select minute(now()) from dual;
select unix_timestamp() from dual;  # seconds from 1970-1-1 0:0:0
select from_unixtime(unix_timestamp(),'%Y-%m-%d %H:%i:%s') from dual;