trim and change date time if in numeric format ssis and sql

trim ssis


LEN(TRIM(my_numeric_value)) == 0 ? "0.00" : TRIM(my_numeric_value)



change date time format


Eq :
input : 20190731
output: 2019-07-31 00:00:00.000

SUBSTRING([FILE-DTE],1,4) + "-" + SUBSTRING([FILE-DTE],5,2) + "-" + SUBSTRING([FILE-DTE],7,2)



change datetime and  numeric format to varchar

'IN1035_' +CAST(col1 AS nvarchar) + '_' + 
FORMAT([LoadDate],'yyyyMMddHHmmss')
AS BT_ID


using CASE:
CASE
WHEN [Code] LIKE '9%' THEN  [aaDate]
WHEN [Code] LIKE '0%' THEN  DATEADD(d,-1,[aaDate])

END AS [PostingDate]