SELECT year(callTheRollTime) from schedule_account 获取年
![](https://images2018.cnblogs.com/blog/1197493/201802/1197493-20180227163717733-1052849583.png)
SELECT month(callTheRollTime) from schedule_account 获取月份
SELECT day(callTheRollTime) from schedule_account 获取日
SELECT date(callTheRollTime) from schedule_account 获取时间 2018-02-27
SELECT hour(callTheRollTime) from schedule_account 获取时
SELECT MINUTE(callTheRollTime) from schedule_account 获取分
SELECT second(callTheRollTime) from schedule_account 获取秒