yyym520的博客

SELECT DATE_FORMAT(表中日期字段名,'%Y-%m-%d %H:%i:%s') as 别名  FROM `表名`； 说明符说明%a工作日的缩写名称  (Sun..Sat)%b月份的缩写名称  (Jan..Dec)%c月份，数字形式(0..12)%D带有英语后缀的该月日期  (0th, 1st, 2nd, 3rd, ...)%d该月日期, 数字形式 (00..31)%e该月日期, 数...

SELECT * FROM (SELECT user_id,(@rowNum:=@rowNum+1) AS rowNoFROM tab_users,(SELECT(@rowNum:=0)) b ORDERBY age DESC) c WHERE user_id=216;