출력값사용방법
Feb 22 2006 4:26PMCONVERT(CHAR(19), CURRENT_TIMESTAMP, 0)
02/22/06CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1)
06.02.22CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2)
2022-02-06CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3)
22.02.06CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4)
2022-02-06CONVERT(CHAR(8), CURRENT_TIMESTAMP, 5)
22-Feb-06CONVERT(CHAR(9), CURRENT_TIMESTAMP, 6)
22-Feb-06CONVERT(CHAR(10), CURRENT_TIMESTAMP, 7)
16:26:08CONVERT(CHAR(8), CURRENT_TIMESTAMP, 8)
Feb 22 2006 4:26:08:020PMCONVERT(CHAR(26), CURRENT_TIMESTAMP, 9)
02-22-06CONVERT(CHAR(8), CURRENT_TIMESTAMP, 10)
2006-02-22CONVERT(CHAR(8), CURRENT_TIMESTAMP, 11)
60222CONVERT(CHAR(6), CURRENT_TIMESTAMP, 12)
22 Feb 2006 16:26:08:020CONVERT(CHAR(24), CURRENT_TIMESTAMP, 13)
16:26:08:037CONVERT(CHAR(12), CURRENT_TIMESTAMP, 14)
2006-02-22 16:26CONVERT(CHAR(19), CURRENT_TIMESTAMP, 20)
26:08.0CONVERT(CHAR(23), CURRENT_TIMESTAMP, 21)
02/22/06 4:26:08 PMCONVERT(CHAR(20), CURRENT_TIMESTAMP, 22)
2006-02-22CONVERT(CHAR(10), CURRENT_TIMESTAMP, 23)
16:26:08CONVERT(CHAR(8), CURRENT_TIMESTAMP, 24)
26:08.0CONVERT(CHAR(23), CURRENT_TIMESTAMP, 25)
Feb 22 2006 4:26PMCONVERT(CHAR(19), CURRENT_TIMESTAMP, 100)
02/22/2006CONVERT(CHAR(10), CURRENT_TIMESTAMP, 101)
2006.02.22CONVERT(CHAR(10), CURRENT_TIMESTAMP, 102)
22/02/2006CONVERT(CHAR(10), CURRENT_TIMESTAMP, 103)
22.02.2006CONVERT(CHAR(10), CURRENT_TIMESTAMP, 104)
22-02-2006CONVERT(CHAR(10), CURRENT_TIMESTAMP, 105)
22-Feb-06CONVERT(CHAR(11), CURRENT_TIMESTAMP, 106)
22-Feb-06CONVERT(CHAR(12), CURRENT_TIMESTAMP, 107)
16:26:08CONVERT(CHAR(8), CURRENT_TIMESTAMP, 108)
Feb 22 2006 4:26:08:067PMCONVERT(CHAR(26), CURRENT_TIMESTAMP, 109)
02-22-2006CONVERT(CHAR(10), CURRENT_TIMESTAMP, 110)
2006-02-22CONVERT(CHAR(10), CURRENT_TIMESTAMP, 111)
20060222CONVERT(CHAR(8), CURRENT_TIMESTAMP, 112)
22 Feb 2006 16:26:08:067CONVERT(CHAR(24), CURRENT_TIMESTAMP, 113)
16:26:08:067CONVERT(CHAR(12), CURRENT_TIMESTAMP, 114)
2006-02-22 16:26CONVERT(CHAR(19), CURRENT_TIMESTAMP, 120)
26:08.1CONVERT(CHAR(23), CURRENT_TIMESTAMP, 121)
2006-02-22T16:26:08.080CONVERT(CHAR(23), CURRENT_TIMESTAMP, 126)
2006-02-22T16:26:08.080CONVERT(CHAR(23), CURRENT_TIMESTAMP, 127)
24 ???? 1427 4:26:08:080PMCONVERT(CHAR(32), CURRENT_TIMESTAMP, 130)
24/01/1427 4:26:08:080PMCONVERT(CHAR(25), CURRENT_TIMESTAMP, 131)



저작자 표시
신고

'[07] Database' 카테고리의 다른 글

[MSSQL] 날짜 형변환  (0) 2014.10.23
MSSQL 인덱스 조각모음 [Microsoft SQL Server 2000 Index Defragmentation Best Practices]  (0) 2013.07.13
Database Shrink를 하지 말아야 하는 이유  (0) 2013.06.14
DA & DBA  (0) 2012.07.04
Big Data + Data Scientist  (0) 2012.06.04
SQLDriverConnect  (0) 2008.11.25
ODBC Error Codes  (0) 2008.11.24
MS-SQL Owner 변경하기  (0) 2008.08.18
블로그 이미지

Moonistar moonistar