Author Message
VadimChaychits2
Joined: Nov 20, 2013
Messages: 24
Offline
Hi

I try send insert into my DB table. Column Time_Stamp has type of datetime (example yyyy-mm-dd hh:mm:ss.SSS)
How I can send correct date and time to this column in correct type (datetime).
Convert Datetime String return value is "Wed Apr 18 13:01:49 MSK 2018", but need "2018-04-18 13:01:49.303"
Thanks
WilsonYu
Joined: Nov 6, 2013
Messages: 3950
Offline
If you are using the OD database operation, it is able to take the Java date object in the variable mapped to the column. You can get the current Java date object into a variable by using the Set Datetime data operation. It takes the date and time system variables which give you the current date and time as the node is executed, and turns it into a Java date object and assign it to the destination variable.
Go to:   
Mobile view