Timediff SQL Ignition

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.


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

These apply for Ms sql as you didn’t specify a sql server