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...
I did find one solution by using java class and it is working properly but prefer to do that in DataWeave if it is possible . package getDate; import java.util.Calendar; import java.text.SimpleDateFormat; public class GetDateByWeekNumber { public static String getDateByWeekNumber(int year...
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...
(Date,Name) (DateTime,Name) (LocalDateTime,Name) (LocalTime,Name) (Object,Name) (Object,String) (Period,Name) (Time,Name) 4|(read(payload.Envelope.Body.wsTestXMLResponse.wsTestXMLResult,"application/xml")).ArrayOfWsTest.wsTest.pass ...