Hello, good afternoon everyone.
I’m actually working on a parts management system and i have a doubt about how to update a column:
The column fecha is the date when the call was initiated.
I need to update every 5 minutes the timediff between the column fecha and the actual time and write it on the timediff column for every row.
Do you know a way to perform this update on SQL in Ignition?
Thanks in advance for your time and help.
Regards.
The timediff column should be a derived column rather than an actual column in your table. If you want to capture historically how long it took, then you cshould have a column that stores the DateTime the process finished as well.
Have a look at these for time diff from now though
https://www.w3schools.com/sql/func_sqlserver_datediff.asp
https://www.w3schools.com/sql/func_sqlserver_getdate.asp
These apply for Ms sql as you didn’t specify a sql server
