본문
- DATE_FORMAT(date,format) <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
format 스트링에 따라서date 값을 포맷한다.
아래에 나와 있는 <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" />지정자 (specifier)들은 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) |
|
%% |
관련링크
- http://jiny.kr/jiny/278 1042회 연결
댓글목록
등록된 댓글이 없습니다.