I have found this as well. Ignition doesn’t seem to recognise the T-SQL datetime2 format as a datetime. I’m pulling data from a query into a table with datetime2 fields, and trying to format the display of them using the object customiser, but they won’t change format. If I change the field format to datetime, then it works… I would much rather use the newer datetime2 format. Is this a known issue?
The newest drivers will need a fairly modern java 8. A fairly modern java 8 may not run such an ancient version of Ignition. Make a complete image backup of that gateway (OS level backup) so you can revert when (likely) this blows up in your face.
If you succeed, please report back. So we can marvel at your accomplishment… /: