mysql 날짜 조회 시 date_format 초기화 하여 셀렉트 하기
2021. 1. 13. 17:47ㆍ데이터베이스/mysql
728x90
반응형
※ 자세한 표현식 표
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
|
--------------------------------------------------------------------------------------------------------------------------
| 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; 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 |
--------------------------------------------------------------------------------------------------------------------------
| %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 % character |
--------------------------------------------------------------------------------------------------------------------------
| %x | x, for any “x” not listed above |
--------------------------------------------------------------------------------------------------------------------------
|
cs |
1. 지금 시간!
|
1
|
SELECT NOW() FROM DUAL;
|
cs |
2. 년월일!
|
1
|
SELECT date_format(NOW(), '%Y-%m-%d') AS date FROM DUAL;
|
cs |
3. 시분초!
|
1
|
SELECT date_format(NOW(), '%H:%i:%s') AS time FROM DUAL;
|
cs |
4. 월,요일,시간!
|
1
|
SELECT date_format(NOW(), '%M - %W - %r') AS date FROM DUAL;
|
cs |
포맷 형식 표에 나온대로 보고 원하는대로 조합해서 셀렉트 할수 있습니다.
728x90
'데이터베이스 > mysql' 카테고리의 다른 글
| mysql 월별 count 통계! (2) | 2021.01.26 |
|---|---|
| mysql 일별 count 통계 쿼리 (2) | 2021.01.26 |
| mysql 테이블 컬럼 정의 쿼리 (0) | 2021.01.11 |