SSIS Date in derived column as yyyy-mm-dd format

Question

I would need date in YYYY-MM-DD format in a ssis derived column,

i am using (DT_DATE)(DT_DBDATE)GETDATE() which is populating as 2013-05-24 00:00:00

Please suggest...

Answer 1

SSIS Derived Column expression variant:

(DT_STR, 4, 1252) DATEPART("yy" , GETDATE())  + "-" + 
RIGHT("0" + (DT_STR, 2, 1252) DATEPART("mm" , GETDATE()), 2)  + 
"-" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("dd" , GETDATE()), 2)