Define whether ClearSCADA Converts Time Stamps to Local Time

Time stamps from the ClearSCADA server use UTC (Coordinated Universal Time), but you can configure your DSN connection so that ClearSCADA 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 ClearSCADA are converted into local time at the client, and queries from the client to ClearSCADA are converted from the client’s local time to UTC.

ClearSCADA will convert any dates/time stamps in SQL queries from local time to UTC (before passing the query to the ClearSCADA 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 ClearSCADA, ClearSCADA will convert the dates and time stamps from the client’s local time into UTC. Similarly, when the client receives data from ClearSCADA, 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.