UNIX TIMESTAMP CONVERT
카테고리 없음 / 2015. 8. 31. 14:59
DATEADD(SECOND, [CREATE_DATE] - DATEDIFF(SECOND,'1970-01-01', DATEADD(HH, -9, GETDATE())), GETDATE())
CONVERT(CHAR(8), DATEADD(SECOND, [CREATE_DATE] - DATEDIFF(SECOND,'1970-01-01', DATEADD(HH, -9, GETDATE())), GETDATE()), 112)