Converting Varchar data into Datetime

[Matt]

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.

[Matt]

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)

[pavan44]

Can you give me the complete expression you are providing and the error as well.

[Matt]

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)

[pavan44]

Matt,

If you copy the expression from here, it will have different quotations (" "). Try to type the entire expression in the mapper instead of copying it from here. It works.

[tlikarish]

The quote thing messed me up when I was trying to help someone with an expression on a different thread. If you wrap the expression in preformatted text using , then it won’t change the quote mark.

For example I think this should copy and paste ok:

Date.parse($MODDATE,"yyyyMMdd hhmmss").toLocaleDateTimeString({"format":"yyyy-MM-dd hh:mm:ss"})