%type jstring=:string {format:"YYYY-MM-dd HH:mm:ss"} %type jdate=:date {format:"YYYY-MM-dd HH:mm:ss"} %namespace ns1 urn:jda:master:item:xsd:3 --- [ { CREDATE: payload.ns1# itemMessage.item.creationDateTime as :localdatetime {format: "yyyy-MM-dd'...
Second, you don´t have to convert the string in a date, you could use the string and the function TO_DATE in the query, below you have an example : <db:insert config-ref="Oracle_Configuration" doc:name="Database"> <db:parameterized-query><![CDATA[insert into TABLE1 (COLUMN1, TE...
In DataWeave, you can parse a string to various Java datetime types ... payload.date as :localdatetime {format: "M/dd/yyyy h:mm:ss a"} as :string {format: "MM/dd/yyyy"} UpvoteReply Log In to AnswerSubscribe to thread Don't see what you're looking for? Ask a Questio...
StartDt: $.Start_Date_Time__c as :localdatetime {format: "YYYY-MM-DDThh:mm:ss.sssZ"} as :date {format: "YYYY-MM-dd"} default "" I am getting an error Cannot coerce a :string to a :localdatetime, caused by :Unknown pattern letter: T does anyone know how to f...