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...
Input String (string, empty with the default setting, must not be empty) String that can be entered using the keyboard or in the wizard, including with the help of the pin variables. Separator Define a separator that the string is to be separated after. In the wizard, you also have the...
INSERT INTO item_sample_date VALUES(# [payload.ITEM],# [payload.DESCR],0,TO-DATE(# [payload.CREDATE],'yyyy/mm/dd hh24:mi:ss'))) This give me missing expression error. Thank you, LalithaDataWeave 1 Upvote Answer Share 2 answers 314 views phulme 7 years ag...
payload.createdDateTime as :datetime {format: "yyyy-MM-dd'T'HH:mm:ssZ"} as :string {format: "ddMMyyyy"}, Using this datetime format I think I am assuming that the date is given to me in z time. How can I change my dataweave expression to cater for if there is a non-zero time...
Please check below DataWeave and let me know if this will work for you %dw 2.0 output application/json var data1 = [ { "partyId": "0201", "relatedPartyId": "123", "relatedPartyLegacyCustomerId": "456", "role": "Payer", "createdDate": "2021-01-22T1...