sql_ssis: Expression used to set the date format like ‘ddmmyy-hhmm’ in SSIS

Tuesday, July 2, 2013

Expression used to set the date format like ‘ddmmyy-hhmm’ in SSIS

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

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

RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , getdate() ), 2)+"_"+Right("0" + (DT_STR,2,1252) DatePart("hh",getdate()),2)

+ Right("0" + (DT_STR,2,1252) DatePart("mi",getdate()),2)

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)