Home Forums Data Warehousing Integration Services How to convert datetime to string format (YYYYMMDD) in SSIS? RE: How to convert datetime to string format (YYYYMMDD) in SSIS?
kl25
Hall of Fame
Points: 3752
More actions
February 28, 2013 at 9:14 am
#1592024
Here's another option.
REPLACE((DT_WSTR, 10)(DT_DBDATE)GETDATE(),"-","")