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
Hey Pavan,
Thank you for the reply, I just have a quick question. If I have a input scheme for example $DATE that’s bringing in data, would I just replace “20170617 125254” with the schema?
Yes, That’s correct.
When I insert my schema this is what I get.
Could not compile expression: Date.parse($MODDATE,“yyyyMMdd … (Reason: Invalid token: ‘“’ for expression: Date.parse($MODDATE,“yyyyMMdd …; Resolution: Please check expression syntax)
Can you give me the complete expression you are providing and the error as well.
Of course,
expression:
Date.parse($MODDATE,“yyyyMMdd hhmmss”).toLocaleDateTimeString({“format”:“yyyy-MM-dd hh:mm:ss”})Validation errors:
property_map.settings.transformations.value.mappingTable.value[2].expression.value: Could not compile expression: Date.parse($MODDATE,“yyyyMMdd … (Reason: Invalid token: ‘“’ for expression: Date.parse($MODDATE,“yyyyMMdd …; Resolution: Please check expression syntax)
