使用DATE_FORMAT()函数
SELECT
NOW()
,DATE_FORMAT(NOW(),'%Y-%m-%d') as '年月日'
,DATE_FORMAT(NOW(),'%T') as '时分秒'
,DATE_FORMAT(NOW(),'%H:%i') as '时分'
结果
使用DATE_FORMAT()函数
SELECT
NOW()
,DATE_FORMAT(NOW(),'%Y-%m-%d') as '年月日'
,DATE_FORMAT(NOW(),'%T') as '时分秒'
,DATE_FORMAT(NOW(),'%H:%i') as '时分'
结果