获取当前年:
select YEAR(NOW()) as `YEAR`
获取当前月:
select MONTH(NOW()) as MONTH
获取当前小时
select HOUR(NOW()) as HOUR
获取当前分钟
select MINUTE(NOW()) as MINUTE
获取当I前秒
select SECOND(NOW()) as SECOND
获取当前季度
select QUARTER(NOW()) as QUARTER
获取当前年:
select YEAR(NOW()) as `YEAR`
获取当前月:
select MONTH(NOW()) as MONTH
获取当前小时
select HOUR(NOW()) as HOUR
获取当前分钟
select MINUTE(NOW()) as MINUTE
获取当I前秒
select SECOND(NOW()) as SECOND
获取当前季度
select QUARTER(NOW()) as QUARTER