"We're observing a discrepancy between the SQL database, where the time is logged as 2:00 AM, and the Ignition perspective table, which shows it as 1:51:10 AM. Do you have any insights into what might be causing this discrepancy?"
What does the column object's dateFormat
look like for the StartDate and EndDate columns?