/*日期函数*/
/*curdate*/
select curdate();
/*curtime*/
select curtime();
/*now*/
select now();
/*year month day*/
select year(now());
select month(now());
select day(now());
/*date_add*/
select date_add(now(),interval 70 month);
/*datediff*/
select datediff(now(),'2021-11-01');/*第一个时间减去第二个时间*/
/*查询所有员工的入职天数,并根据入职天数倒序排序*/
select name,datediff(curdate(),entrydate) from emp order by datediff(curdate(),entrydate) desc;