mysql date_format格式参数整理

 

世纪
年		%X	Year for the week where Sunday is the first day of the week, numeric,four digits; used with %V
		%x	Year for the week, where Monday is the first day of the week,numeric, four digits; used with %v
		%Y	Year, numeric, four digits
		%y	Year, numeric (two digits)
季度
月		%b	Abbreviated month name (Jan..Dec)
		%M	Month name (January..December)
		%c	Month, numeric (0..12)
		%m	Month, numeric (00..12)
星期		%a	Abbreviated weekday name (Sun..Sat)
		%W	Weekday name (Sunday..Saturday)
		%U	Week (00..53), where Sunday is the first day of the week; WEEK() mode 0
		%u	Week (00..53), where Monday is the first day of the week; WEEK() mode 1
		%V	Week (01..53), where Sunday is the first day of the week; WEEK() mode 2; used with %X
		%v	Week (01..53), where Monday is the first day of the week; WEEK() mode 3; used with %x
日	天（年）	%j	Day of year (001..366)
	天（月）	%d	Day of the month, numeric (00..31)
		%e	Day of the month, numeric (0..31)
		%D	Day of the month with English suffix (0th, 1st, 2nd, 3rd, …)
	天（周）	%w	Day of the week (0=Sunday..6=Saturday)
小时	24小时制	%H	Hour (00..23)
		%k	Hour (0..23)
	12小时制	%h	Hour (01..12)
		%I	Hour (01..12)
		%l	Hour (1..12)
		%p	AM or PM
		%r	Time, 12-hour (hh:mm:ss followed by AM or PM)
		%T	Time, 24-hour (hh:mm:ss)
分钟		%i	Minutes, numeric (00..59)
秒		%S	Seconds (00..59)
		%s	Seconds (00..59)
毫秒		%f	Microseconds (000000..999999)