Artifact | Statement |
Date String – YYYYMMDD | (DT_WSTR, 4)(DATEPART(“YEAR”, GETDATE())) + RIGHT(“00” + (DT_WSTR, 4)(DATEPART(“MONTH”, GETDATE())), 2) + RIGHT(“00” + (DT_WSTR, 4)(DATEPART(“DAY”, GETDATE())), 2) |
Time String – HHMMSS | RIGHT(“00” + (DT_WSTR, 4)(DATEPART(“HOUR”, GETDATE())), 2) + RIGHT(“00” + (DT_WSTR, 4)(DATEPART(“MINUTE”, GETDATE())), 2) + RIGHT(“00” + (DT_WSTR, 4)(DATEPART(“SECOND”, GETDATE())), 2) |