Notice
Recent Posts
Recent Comments
Link
| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 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 |
Tags
- swift
- node.js
- 맛집
- Excel
- Linux
- 다이어트
- mssql
- Unity
- python
- MS-SQL
- PyQt5
- PyQt
- javascript
- MySQL
- 라즈베리파이
- urllib
- 날짜
- sqlite
- 함수
- flutter
- 리눅스
- ASP
- pandas
- IOS
- tensorflow
- ubuntu
- port
- PER
- 유니티
- GIT
Archives
아미(아름다운미소)
[MSSQL]날짜 변환표(GETDATE, CONVERT) 본문
쿼리 |
결과 |
코드 |
| CONVERT(CHAR(19), DATETIME, 0) | 01 02 2000 1:14PM | MM DD YYYY H:MM |
| CONVERT(CHAR(10), DATETIME, 1) | 01/02/2000 | MM/DD/YYYY |
| CONVERT(CHAR(8), DATETIME, 2) | 00.01.02 | YY.MM.DD |
| CONVERT(CHAR(8), DATETIME, 3) | 02/01/00 | DD/MM/YY |
| CONVERT(CHAR(8), DATETIME, 4) | 02.01.00 | DD.MM.YY |
| CONVERT(CHAR(8), DATETIME, 5) | 02-01-00 | DD-MM-YY |
| CONVERT(CHAR(8), DATETIME, 6) | 02 01 00 | DD MM YY |
| CONVERT(CHAR(9), DATETIME, 7) | 01 02, 00 | MM DD, YY |
| CONVERT(CHAR(8), DATETIME, 8) | 13:14:15 | HH:MM:SS |
| CONVERT(CHAR(26), DATETIME, 9) | 01 02 2000 1:14:15.678PM | NN DD YYYY H:MM:SS.MS |
| CONVERT(CHAR(8), DATETIME, 10) | 01-02-00 | MM-DD-YY |
| CONVERT(CHAR(8), DATETIME, 11) | 02/01/00 | DD/MM/YY |
| CONVERT(CHAR(6), DATETIME, 12) | 000102 | YYMMDD |
| CONVERT(CHAR(24), DATETIME, 13) | 02 01 2000 13:14:15.678 | DD MM YYYY HH:MM:SS.MS |
| CONVERT(CHAR(12), DATETIME, 14) | 13:14:15.678 | HH:MM:SS.MS |
| CONVERT(CHAR(19), DATETIME, 20) | 2000-01-02 13:14:15 | YYYY-MM-DD HH:MM:SS |
| CONVERT(CHAR(23), DATETIME, 21) | 2000-01-02 13:14:15.678 | YYYY-MM-DD HH:MM:SS.MS |
| CONVERT(CHAR(20), DATETIME, 22) | 01/02/00 1:14:15 PM | MM/DD/YY H:M:S |
| CONVERT(CHAR(10), DATETIME, 23) | 2000-01-02 | YYYY-MM-DD |
| CONVERT(CHAR(8), DATETIME, 24) | 13:14:15 | HH:MM:SS |
| CONVERT(CHAR(23), DATETIME, 25) | 2000-01-02 13:14:15.678 | YYYY-MM-DD HH:MM:SS.MS |
| CONVERT(CHAR(19), DATETIME, 100) | 01 02 2000 1:02PM | MM DD YYYY H:MM |
| CONVERT(CHAR(10), DATETIME, 101) | 01/02/2000 | MM/DD/YYYY |
| CONVERT(CHAR(10), DATETIME, 102) | 2000.01.02 | YYYY.MM.DD |
| CONVERT(CHAR(10), DATETIME, 103) | 02/01/2000 | DD/MM/YYYY |
| CONVERT(CHAR(10), DATETIME, 104) | 02/01/2000 | DD/MM/YYYY |
| CONVERT(CHAR(10), DATETIME, 105) | 02-01-2000 | DD-MM-YYYY |
| CONVERT(CHAR(11), DATETIME, 106) | 02 01 2000 | DD MM YYYY |
| CONVERT(CHAR(12), DATETIME, 107) | 01 02, 2000 | MM DD, YYYY |
| CONVERT(CHAR(8), DATETIME, 108) | 13:14:15 | HH:MM:SS |
| CONVERT(CHAR(26), DATETIME, 109) | 01 02 2000 1:14:15.678PM | MM DD YYYY H:MM:DD.MS |
| CONVERT(CHAR(10), DATETIME, 110) | 01-02-2000 | MM-DD-YYYY |
| CONVERT(CHAR(10), DATETIME, 111) | 2000/01/02 | YYYY/MM/DD |
| CONVERT(CHAR(8), DATETIME, 112) | 20000102 | YYYYMMDD |
| CONVERT(CHAR(24), DATETIME, 113) | 02 01 2000 13:14:15.678 | DD MM YYYY HH:MM:DD.MS |
| CONVERT(CHAR(12), DATETIME, 114) | 13:14:15:678 | HH:MM:DD:MS |
| CONVERT(CHAR(19), DATETIME, 120) | 2000-01-02 13:14:15 | YYYY-MM-DD HH:MM:SS |
| CONVERT(CHAR(23), DATETIME, 121) | 2000-01-02 13:14:15.678 | YYYY-MM-DD HH:MM:SS.MS |
| CONVERT(CHAR(23), DATETIME, 126) | 2000-01-02T13:14:15.678 | YYYY-MM-DDT HH:MM:SS.MS |
| CONVERT(CHAR(23), DATETIME, 127) | 2000-01-02T13:14:15.678 | YYYY-MM-DDT HH:MM:SS.MS |
| CONVERT(CHAR(25), DATETIME, 131) | 1/06/1421 1:13:14:678PM | |
| CONVERT(CHAR(23), DATETIME, 21) | 2000-01-02 13:14:15.678 | YYYY-MM-DD HH:MM:SS.MS |
| CONVERT(CHAR(10), DATETIME, 23) | 2000-01-02 | YYYY-MM-DD |
| CONVERT(CHAR(8), DATETIME, 112) | 20000102 | YYYYMMDD |
'데이타베이스 > MSSQL' 카테고리의 다른 글
| Table 컬럼 추가 및 삭제 변경 (0) | 2019.02.13 |
|---|---|
| Ms-Sql 랜덤 정렬 newid() (0) | 2019.01.11 |
| SQL Server 로그축소 (0) | 2018.12.28 |
| MS-SQL 인덱스 생성 및 삭제 (0) | 2018.11.20 |
| [MSSQL]날짜계산함수 datediff, dateadd (0) | 2018.11.19 |
Comments