I just need a gut check on time zones and datatypes.
I have a server running MS SQL and Ignition set to UTC time. I have quite of few queries using the GETUTCTIME() MS SQL function. I had the same project running in two time zones (EST AND HST) and to keep my sanity, I switched EVERYTHING to UTC. My computer, servers, etc. Now, more people are using it so I'm switching back to client side time zones. Luckily we're only in EST now.
Based on all my testing, I should be ok since most scripts are gateway scope (UTC still) and Ignition does a decent job converting time zones for data entry. Backend, everything should still be UTC. So I'm setting my project time zone to CLIENT or EST, depending on feedback from co-workers.
BUT, am I missing anything?