728x90
728x90
CONVERT에 다양한 형식의 datetime 데이터 사용
| 문법 | 예상결과 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 0) | Jul 5 2023 4:29AM |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 1)
|
07/05/23 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 2) | 23.07.05 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 3) | 05/07/23 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 4) | 05.07.23 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 5) | 05-07-23 |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 6)
|
05 Jul 23 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 7) | Jul 05, 23 |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 8)
SELECT CONVERT(NVARCHAR, GETDATE(), 24) SELECT CONVERT(NVARCHAR, GETDATE(), 108) |
04:32:08 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 9) SELECT CONVERT(NVARCHAR, GETDATE(), 109) |
Jul 5 2023 4:32:40:790AM |
| SELECT CONVERT(NVARCHAR, GETDATE(), 10) | 07-05-23 |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 11)
|
23/07/05 |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 12)
|
230705 |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 13)
SELECT CONVERT(NVARCHAR, GETDATE(), 113) |
05 Jul 2023 04:33:33:760 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 14) SELECT CONVERT(NVARCHAR, GETDATE(), 114) |
04:33:52:587 |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 20)
SELECT CONVERT(NVARCHAR, GETDATE(), 120) |
2023-07-05 04:34:19 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 21) SELECT CONVERT(NVARCHAR, GETDATE(), 25) SELECT CONVERT(NVARCHAR, GETDATE(), 121) |
2023-07-05 04:34:34.463 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 22) | 07/05/23 4:35:09 AM |
| SELECT CONVERT(NVARCHAR, GETDATE(), 23) | 2023-07-05 |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 101)
|
07/05/2023 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 102) | 2023.07.05 |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 103)
|
05/07/2023 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 104) | 05.07.2023 |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 105)
|
05-07-2023 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 106) | 05 Jul 2023 |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 107)
|
Jul 05, 2023 |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 110)
|
07-05-2023 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 111) | 2023/07/05 |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 112)
|
20230705 |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 113)
|
05 Jul 2023 04:37:54:427 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 120) | 2023-07-05 04:38:06 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 121) | 2023-07-05 04:38:16.037 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 126) | 2023-07-05T04:38:27.690 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 127) | 2023-07-05T04:38:36.793 |
| SELECT CONVERT(NVARCHAR, GETDATE(), 130) |  |
|
SELECT CONVERT(NVARCHAR, GETDATE(), 131)
|
17/12/1444 4:39:23:623AM |
[참고]
728x90
300x250
'Database > MS-SQL' 카테고리의 다른 글
| [MS-SQL; 엠에스에스큐엘] BETWEEN절 문법 & 예제 (0) | 2023.07.07 |
|---|
