문서의 선택한 두 판 사이의 차이를 보여줍니다.
양쪽 이전 판 이전 판 다음 판 | 이전 판 | ||
database:mysql:date [2012/12/27 19:59] kwon37xi [MySQL Date Functions] |
database:mysql:date [2016/03/02 17:21] (현재) kwon37xi |
||
---|---|---|---|
줄 1: | 줄 1: | ||
====== MySQL Date Functions ====== | ====== MySQL Date Functions ====== | ||
* http:// | * http:// | ||
+ | |||
+ | ===== DATETIME 타입 ===== | ||
+ | * MySQL 5.6 부터 '' | ||
+ | `createdAt` datetime DEFAULT CURRENT_TIMESTAMP 가 있을 때, | ||
+ | |||
+ | ERROR 1067 (42000): Invalid default value for ' | ||
+ | </ | ||
+ | |||
===== date ===== | ===== date ===== | ||
* 날짜/ | * 날짜/ | ||
줄 35: | 줄 43: | ||
DAY_HOUR | DAY_HOUR | ||
YEAR_MONTH | YEAR_MONTH | ||
+ | </ | ||
+ | |||
+ | ===== str_to_date/ | ||
+ | * 문자열을 DATETIME 으로 변경< | ||
+ | STR_TO_DATE(str, | ||
+ | </ | ||
+ | * DATETIME을 문자열로 변경< | ||
+ | DATE_FORMAT(date, | ||
+ | </ | ||
+ | * 예 : < | ||
+ | SELECT DATE_FORMAT(now(),' | ||
+ | SELECT STR_TO_DATE(' | ||
+ | </ | ||
+ | * Format < | ||
+ | Specifier Description | ||
+ | %a Abbreviated weekday name (Sun..Sat) | ||
+ | %b Abbreviated month name (Jan..Dec) | ||
+ | %c Month, numeric (0..12) | ||
+ | %D Day of the month with English suffix (0th, 1st, 2nd, 3rd, ) | ||
+ | %d Day of the month, numeric (00..31) | ||
+ | %e Day of the month, numeric (0..31) | ||
+ | %f Microseconds (000000..999999) | ||
+ | %H Hour (00..23) | ||
+ | %h Hour (01..12) | ||
+ | %I Hour (01..12) | ||
+ | %i Minutes, numeric (00..59) | ||
+ | %j Day of year (001..366) | ||
+ | %k Hour (0..23) | ||
+ | %l Hour (1..12) | ||
+ | %M Month name (January..December) | ||
+ | %m Month, numeric (00..12) | ||
+ | %p AM or PM | ||
+ | %r Time, 12-hour (hh:mm:ss followed by AM or PM) | ||
+ | %S Seconds (00..59) | ||
+ | %s Seconds (00..59) | ||
+ | %T Time, 24-hour (hh:mm:ss) | ||
+ | %U Week (00..53), where Sunday is the first day of the week | ||
+ | %u Week (00..53), where Monday is the first day of the week | ||
+ | %V Week (01..53), where Sunday is the first day of the week; used with %X | ||
+ | %v Week (01..53), where Monday is the first day of the week; used with %x | ||
+ | %W Weekday name (Sunday..Saturday) | ||
+ | %w Day of the week (0=Sunday..6=Saturday) | ||
+ | %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) | ||
+ | %% A literal ' | ||
+ | %x x, for any ' | ||
</ | </ |