Define whether Geo SCADA Expert Converts Time Stamps to Local Time

Time stamps from the Geo SCADA Expert server use UTC (Coordinated Universal Time), but you can configure your DSN connection so that Geo SCADA Expert converts the times, dates and time stamps from UTC to Local Time. Local time is the local time zone, with Daylight Saving Time where applicable, on the client on which you are configuring the DSN.

If you enable Local Time conversion, the conversion is applied in both directions - UTC times, dates, and time stamps from Geo SCADA Expert are converted into local time at the client, and queries from the client to Geo SCADA Expert are converted from the client’s local time to UTC.

Geo SCADA Expert will convert any dates/time stamps in SQL queries from local time to UTC (before passing the query to the Geo SCADA Expert server). The following date/time stamp formats are supported:

{d 'yyyy-MM-dd'}

{ts 'yyyy-MM-dd HH:mm:ss.SSS'}

DATE 'yyyy-MM-dd'

TIMESTAMP 'yyyy-MM-dd HH:mm:ss.SSS'

You can use the Local Time check box on the ODBC Setup window to define whether times, dates, and time stamps are converted from UTC into Local Time/Local Time into UTC:

1. Display the ODBC Setup window Configure the ODBC DSN Settings
2. Use the Local Time check box to define your preference:
   • Select (check) the Local Time check box to enable Local Time conversion for the DSN connection. When the client sends a query to Geo SCADA Expert, Geo SCADA Expert will convert the dates and time stamps from the client’s local time into UTC. Similarly, when the client receives data from Geo SCADA Expert, the client will convert the dates and time stamps from UTC into local time.
   • Clear the Local Time check box if time conversion is not to be used. Dates and time stamps will be in UTC.