%Y: Year, numeric, four digits : DATE_FORMAT « Date Time Functions « MySQL Tutorial






mysql>
mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%Y');
+------------------------------------------+
| DATE_FORMAT('1997-10-04 22:23:00', '%Y') |
+------------------------------------------+
| 1997                                     |
+------------------------------------------+
1 row in set (0.00 sec)








14.11.DATE_FORMAT
14.11.1.DATE_FORMAT()
14.11.2.Dates can also be formatted in 'plain english'
14.11.3.Using DATE_FORMAT() with an alias to tidy up the title
14.11.4.%a: Abbreviated weekday name (Sun..Sat)
14.11.5.%b: Abbreviated month name (Jan..Dec)
14.11.6.%c: Month, numeric (0..12)
14.11.7.%D: Day of the month with English suffix (0th, 1st, 2nd, 3rd, ...)
14.11.8.%d: Day of the month, numeric (00..31)
14.11.9.%e: Day of the month, numeric (0..31)
14.11.10.%f: Microseconds (000000..999999)
14.11.11.%H: Hour (00..23)
14.11.12.%h: Hour (01..12)
14.11.13.%I: Hour (01..12)
14.11.14.%i: Minutes, numeric (00..59)
14.11.15.%j: Day of year (001..366)
14.11.16.%k: Hour (0..23)
14.11.17.%l: Hour (1..12)
14.11.18.%M: Month name (January..December)
14.11.19.%m: Month, numeric (00..12)
14.11.20.%p: AM or PM
14.11.21.%r: Time, 12-hour (hh:mm:ss followed by AM or PM)
14.11.22.%S: Seconds (00..59)
14.11.23.%T: Time, 24-hour (hh:mm:ss)
14.11.24.%U: Week (00..53), where Sunday is the first day of the week
14.11.25.%u: Week (00..53), where Monday is the first day of the week
14.11.26.%V: Week (01..53), where Sunday is the first day of the week; used with %X
14.11.27.%v: Week (01..53), where Monday is the first day of the week
14.11.28.%W: Weekday name (Sunday..Saturday)
14.11.29.%w: Day of the week (0=Sunday..6=Saturday)
14.11.30.%X: Year for the week where Sunday is the first day of the week, numeric, four digits
14.11.31.%x: Year for the week, where Monday is the first day of the week, numeric, four digits
14.11.32.%Y: Year, numeric, four digits
14.11.33.%y: Year, numeric (two digits)
14.11.34.%%: A literal '%' character
14.11.35.SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
14.11.36.SELECT DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
14.11.37.SELECT DATE_FORMAT('1997-10-04 22:23:00','%D %y %a %d %m %b %j');
14.11.38.SELECT DATE_FORMAT('1997-10-04 22:23:00','%H %k %I %r %T %S %w');
14.11.39.SELECT DATE_FORMAT('1999-01-01', '%X %V');
14.11.40.SELECT DATE_FORMAT('2006-06-00', '%d');