Converting Varchar data into Datetime
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 b...
Forum Discussion
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)
