Hello All,
I need to convert timestamp(2014-06-19 00:00:00.000) to Integer(yyyyMMdd) in ADF dataflow. I have used derived column and in the expression i wrote this below
toInteger(toString(toDate('2014-06-19 00:00:00.000', 'yyyy-MM-dd HH:mm:ss'), 'yyyyMMdd'))
and its working perfectly am able to convert to integer required format but the data is taking default value which i kept in the expression i.e..,2014-06-19 00:00:00.000
when i tried to replace with column name like below :
toInteger(toString(toDate('modified', 'yyyy-MM-dd HH:mm:ss'), 'yyyyMMdd')) , am receiving null values.
Could someone help me here?
and upvote
for the same. And, if you have any further query do let us know.
