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 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
