5/30/2018

Format Date in SSIS MM-DD-YYYY or MM/DD/YYYY DD-MM-YYYY or DD/MM/YYYY


Format Date in SSIS MM-DD-YYYY or MM/DD/YYYY DD-MM-YYYY or DD/MM/YYYY

Date Format MM-DD-YYYY:

RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , getdate() ), 2)

+"-"+RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , getdate() ), 2) +"-"+

(DT_STR,4,1252)DATEPART( "yyyy" , getdate() )

Date Format MM/DD/YYYY:

RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , getdate() ), 2)

+"/"+RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , getdate() ), 2) +"/"+

(DT_STR,4,1252)DATEPART( "yyyy" , getdate() )

Date Format DD-MM-YYYY:

RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , getdate() ), 2) +"-"+

RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , getdate() ), 2)

+"-"+(DT_STR,4,1252)DATEPART( "yyyy" , getdate() )

Date Format DD/MM/YYYY:

RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , getdate() ), 2) +"/"+

RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , getdate() ), 2)

+"/"+(DT_STR,4,1252)DATEPART( "yyyy" , getdate() )