Hi everyone,
I’ve been trying to convert data I’m receiving from a varchar (20171211 125023) into a datetime (2017-12-11 12:50:23). I’ve been messing with the mapper but I feel like I’m at a road block now. I was wondering if someone in the community has any success in this.
Hi Matt
You can use Date.parse() function to convert input string to Datetime.
Date.parse(“20170604 125452”, “yyyyMMdd HHmmss”)
this will give desired output.
convertVarcharToDate_2018_12_06.slp (2.6 KB)
Hi Matt,
You can try with the below expression in your mapper. Hope this helps
Date.parse(“20170617 125254”,“yyyyMMdd hhmmss”).toLocaleDateTimeString({“format”:“yyyy-MM-dd hh:mm:ss”})
The output value will be
Hi, This thread was very helpful as I was facing the same issue - I have another question, what to do if we want to pass null values in this same format?
