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 @Thom ,
I’ve attached a pipeline, hope this helps.
Test_Expression_2023_05_31.slp (3.5 KB)
Cheers 😉
Thanks so much. This worked as needed.
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)
