convert + substring, replace(convert)

CONVERT(CHAR(19), REG_DM, 120) REG_DM

결과값

2000-00-00 00:00:00

 

 SQL.append("isnull(substring(reg_dm,3,2)+'-'+substring(reg_dm,5,2)+'-'+substring(reg_dm,7,2)+' '+substring(reg_dm,9,2)+':'+substring(reg_dm,11,2)+':'+substring(reg_dm,13,2),'') as reg_dm,");

결과값

00-00-00 0:00:00

 

Replace(Convert(varchar(8),Getdate(),108),':','')

REPLACE(CONVERT(VARCHAR(10),B.DT_OPEN,120),'-','')

 

REPLACE(값,검색값,변형값)