mysql date_format格式参数整理

最新推荐文章于 2025-11-06 15:53:30 发布

原创最新推荐文章于 2025-11-06 15:53:30 发布 · 811 阅读

CC 4.0 BY-SA版权

16 篇文章

订阅专栏

本文详细解析了日期时间格式中的各种符号及其含义，包括年、月、日、小时、分钟和秒等的时间表示方法，并区分了不同的显示格式。

世纪
年		%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)
	24小时制	%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)