목록변환 (1)

bboks.net™

MS SQL DATETIME 형식 변환

0 Feb 22 2006 4:26PM CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) 1 02/22/06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1) 2 06.02.22 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2) 3 22/02/06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3) 4 22.02.06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4) 5 22-02-06 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 5) 6 22 Feb 06 CONVERT(CHAR(9), CURRENT_TIMESTAMP, 6) 7 Feb 22, 06 CONVERT(CHAR(10), CURRE..
Database/MS-SQL 2010. 8. 3. 15:55
이전 Prev 1 Next 다음