It gives me below preview it convert into date but not as expected. It shows Mon Jan 18 00:00:00 IST 2016 Also, I tried converting it to string and then used the below statement to insert into the database INSERT INTO item_sample_date VALUES(# [payload.ITEM...
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...
"type" : "string", "value" : item.email }, { "name" :"openingHoursByDate", "type" : "JSON", "value" : payload.stores.trading_hours update "value" with ($ pluck (($$)++$) map(value,key) -> { "date" : (value splitBy "T")[0], "dayStart" : convert((value splitBy "Z...
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"} :string {format: "YYYY-MM-dd"} UpvoteReply Log In to Answer Subscribe to thread Don't see what you're looking for? Ask a Question Contact...