old/SQL
변환 함수 (CAST)
jazzlife
2010. 3. 15. 14:24
CAST 함수 : 데이터형을 변환시키는 함수
ex)
ex)
CAST(0.245 AS VARCHAR)
CAST('2010-03-01' AS DATETIME)
CAST('2010-03-01' AS DATETIME)
SELECT time AS moonjayeol, CAST(time AS DATETIME) AS nalzza
FROM tbl_schedule;
FROM tbl_schedule;