Passing DateTime End Up Having Date Only

[john.hadikusumo]

I am working on Ignition 8.3 project and found something bothered me. I notice that evertytime i tried to pass datetime data into my scripting method, only date that was written onto my database table.

My table is simple. It has 2 fields that has DateTime data type.

Picture 1.

The stored procedure for insertion also simple. I had tested and worked as what it was suppose to.

Picture 2.

This is my scripting that calling the stored procedure and passing the parameters into it.

Picture 3

This is my test console. When i worked on ignition 8.1, i didn’t get a problem at all. All date and time was correctly written into database. But on Ignition 8.3 seems not working completely correct.

Picture 4

So if i execute the script above, i only get Date only without the times.

Picture 5

Just wondering if you know how to mitigate this issue or at least pin point me out where i made a mistake.

Thank you

[paul-griffith]

system.db.DATE is the wrong constant; you should be using system.db.TIMESTAMP. If it worked before, it's likely because your JDBC driver was being less strict, but the JDBC driver provided for your DB in 8.3 (correctly) truncates to a date only.

[john.hadikusumo]

Thank you