[Mysql]날짜 포맷(Date Format)
날짜, 시간에 사용되는 포멧
| Format | 설명 |
|---|---|
| %a | 요일 단축 영문명 > select date_format(now(), ‘%a’); Fri |
| %b | 월 단축 영문명 > select date_format(now(), ‘%b’); Feb |
| %c | 월 (0 ~ 12) > select date_format(now(), ‘%c’); 2 |
| %D | Day of the month as a numeric value, followed by suffix (1st, 2nd, 3rd, …) > select date_format(‘2023-01-01’, ‘%D’); 1st |
| %d | Day of the month as a numeric value (01 to 31) > select date_format(‘2023-01-01’, ‘%d’); 01 |
| %e | Day of the month as a numeric value (0 to 31) > select date_format(‘2023-01-01’, ‘%e’); 1 |
| %f | Microseconds (000000 to 999999) > select date_format(‘2023-01-01 13:30:12.123456’, ‘%f’); 123456 |
| %H | Hour (00 to 23) > select date_format(‘2023-01-01 13:30:12.123456’, ‘%H’); 13 |
| %h | Hour (00 to 12) > select date_format(‘2023-01-01 13:30:12.123456’, ‘%h’); 01 |
| %I | Hour (00 to 12) > select date_format(‘2023-01-01 13:30:12.123456’, ‘%I’); 01 |
| %i | Minutes (00 to 59) > select date_format(‘2023-01-01 13:30:12.123456’, ‘%i’); 30 |
| %j | Day of the year (001 to 366) > select date_format(‘2023-01-01 13:30:12.123456’, ‘%j’); 001 |
| %k | Hour (0 to 23) |
| %l | Hour (1 to 12) |
| %M | Month name in full (January to December) |
| %m | Month name as a numeric value (00 to 12) |
| %p | AM or PM |
| %r | Time in 12 hour AM or PM format (hh:mm:ss AM/PM) |
| %S | Seconds (00 to 59) |
| %s | Seconds (00 to 59) |
| %T | Time in 24 hour format (hh:mm:ss) |
| %U | Week where Sunday is the first day of the week (00 to 53) |
| %u | Week where Monday is the first day of the week (00 to 53) |
| %V | Week where Sunday is the first day of the week (01 to 53). Used with %X |
| %v | Week where Monday is the first day of the week (01 to 53). Used with %x |
| %W | Weekday name in full (Sunday to Saturday) |
| %w | Day of the week where Sunday=0 and Saturday=6 |
| %X | Year for the week where Sunday is the first day of the week. Used with %V |
| %x | Year for the week where Monday is the first day of the week. Used with %v |
| %Y | Year as a numeric, 4-digit value |
| %y | Year as a numeric, 2-digit value |
최신 댓글