Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Notifications
Login / Register
Community
Community
Notifications
close
  • Forums
  • Knowledge Center
  • Events & Webinars
  • Ideas
  • Blogs
Help
Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Login / Register
Sustainability
Sustainability

We Value Your Feedback!
Could you please spare a few minutes to share your thoughts on Cloud Connected vs On-Premise Services. Your feedback can help us shape the future of services.
Learn more about the survey or Click here to Launch the survey
Schneider Electric Services Innovation Team!

Local Time vs UTC Time in ClearSCADA

Geo SCADA Knowledge Base

Access vast amounts of technical know-how and pro tips from our community of Geo SCADA experts.

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Home
  • Schneider Electric Community
  • Knowledge Center
  • Geo SCADA Knowledge Base
  • Local Time vs UTC Time in ClearSCADA
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
Top Labels
Top Labels
  • Alphabetical
  • database 32
  • Web Server and Client 31
  • WebX 19
  • Request Form 18
  • Lists, Events & Alarms 16
  • ViewX 15
  • Application Programming 12
  • Setup 12
  • Telemetry 8
  • Events & Alarms 7
  • Lists 7
  • Mimic Graphics 7
  • Downloads 6
  • Support 5
  • IoT 5
  • SCADA 5
  • Geo SCADA Expert 5
  • Drivers and Communications 4
  • Security 4
  • DNP 3 3
  • IEC 61131-3 Logic 3
  • Trends and Historian 2
  • Virtual ViewX 2
  • Geo Scada 1
  • ClearSCADA 1
  • Templates and Instances 1
  • Releases 1
  • Maps and GIS 1
  • Mobile 1
  • Architectures 1
  • Tools & Resources 1
  • Privacy Policy 1
  • OPC-UA 1
  • Previous
  • 1 of 4
  • Next
Latest Blog Posts
  • OPC UA - Driver and Server
  • Requirements for Generating a Valid OPC UA Server Certificate
  • Load Events Using LoadRecord and LoadRecords
  • Geo SCADA Embedded Component Licenses
  • Geo SCADA 2023 Known Issues
Related Products
product field
Schneider Electric
EcoStruxure™ Geo SCADA Expert

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague Invite
Anonymous user
Not applicable
‎2021-06-09 08:36 AM
0 Likes
0
1879
  • Bookmark
  • Subscribe
  • Email to a Friend
  • Printer Friendly Page
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2021-06-09 08:36 AM

Local Time vs UTC Time in ClearSCADA

Originally published on Geo SCADA Knowledge Base by Anonymous user | June 09, 2021 05:36 PM

📖 Home  Back  
Since ClearSCADA is designed as a SCADA system capable of supporting large systems across large geographical regions, the issue if time zones needs to be understood.  How does ClearSCADA handle clients in different time zones, and how are timestamps stored in the database? What happens when a client is to display data that uses different daylight saving times, particularly at the transition times between daylight saving and non-daylight saving times?

All times in the ClearSCADA database are stored in UTC (Coordinated Universal Time). The times are converted from UTC to local time when they are displayed.

The following sections describe how local times (including daylight saving times) are converted into UTC:





Time Zones for Outstations/PLCs



Outstations that use protocols that report time must use the same time zone settings as ClearSCADA . For this reason, most outstations and PLCs operate in UTC (where time is required) so that all times at the server and at the outstations and PLCs are in UTC.

We recommend that your outstations and PLCs operate in UTC. However, some drivers allow the time zone of the outstations/PLCs to be configured on a per-channel basis (defined in the Time Zone field on the Channel Form). The driver for the outstation/PLC will convert all times received from the outstation/PLC into UTC before storing the data in the ClearSCADA  database. The driver will also use the Time Zone setting to set the outstation/PLC's clock (where this is supported by the device and communications protocol).

If the outstation/PLC is using UTC, the times received from the outstation/PLC will be added directly to the ClearSCADA database. If the outstation/PLC is  using local time, the times it reports ClearSCADA  will be converted into UTC in ClearSCADA . The conversion into UTC will take into account any daylight saving time settings that are in place.





Time Zones for ViewX Clients



ViewX clients can have different time zones to the server. This is possible as each ViewX client can have its own local time settings and convert times received from the server (which are sent in UTC) into local times at the client. The local time for a client (including daylight saving time) is determined by the Time Zone of the client PC (defined via the 'Date and Time' control panel applet in Windows).

When you view time data on a client, the times are shown in the local time of the client (unless the Display Times in UTC feature is enabled, see below). This means that all of the times on display are relative to the local time of the client.

To achieve this, all time values that are sent from the server to the client and from the client to the server are sent in UTC. When a client first connects with a server, it sends information about its time zone setting to the server. The server stores this information and uses it if it needs to convert any of the time values being sent to the client.

For most time values, the server sends the time values in UTC and the client converts these values into local time values itself. Similarly, the client will convert any time values it sends to the server from its own local time into UTC before sending the data. However, there are some time values that the server has to convert before it sends them to the client: time values that are within other values. For example, if the server is sending data for a status display and that status display contains a time value that is embedded within a string, the client will not be able to convert the time value as it regards the value as a string. To ensure that the client displays the embedded value in the client's local time, the server uses the local time setting information that the client sent when it first connected to the server to determine the local time of the client. It then converts the embedded time into the corresponding time at the client, before sending the string (that contains the time) to the client.

If your client PC is using daylight saving time and it makes a request to display a time value from a server that is not using daylight saving time, the time will be displayed on your client in your client's local time. If your client requests a time value from in or around the time of transition (the time when daylight saving time begins or ends), you may notice some anomalies, namely:
  • The time of the transition is repeated (when clock goes backwards)

  • The time of transition is missing (when the clock goes forwards)


For example, traditionally North America changes from local standard time (LST) to local daylight time (LDT) at 02:00 am on the first Sunday in April each year. (From 2007, this will change to the second Sunday in March, but may revert to the first Sunday in April at a later date). So, at 02:00 am LDT on the first Sunday in April, time changes to 03:00 am LST. As the time has moved forward, there is a gap in the data in ClearSCADA .

If you were to look at a point's values for this time on a Trend, the Trend could appear something like this:


Trend Clock Forward at DST.JPGTrend Clock Forward at DST.JPGTrend Clock Forward at DST.JPG
Notice that at 01:00, the time jumps ahead an hour to 02:00.



Trend Clock Backward at DST.JPGTrend Clock Backward at DST.JPGTrend Clock Backward at DST.JPG
Notice that at 02:00, the time jumps back an hour to 01:00, so there are 2 01:00s shown on the Trend.



In both cases, there is no duplicate data or loss of data for the transition time as the times are in UTC (the time on the Trends' axes jumps by an hour or repeats an hour as the axes show local time, not UTC time). For example, if the second Trend shown above also had a UTC axis, the axis would look like this:

Trend Clock Change Dual Axis.JPGTrend Clock Change Dual Axis.JPGTrend Clock Change Dual Axis.JPG
This assumes that the local time is Eastern Daylight Time (U.S.A) and is switching to Eastern Standard Time on 30th October. As EST is 5 hours behind UTC time, the value for 00:00 (EST) on the Trend is stored in the database as a value for 05:00 (UTC).



So, when you view a time value on a ViewX client, the time value is always shown in the client's local time i.e. relative to the time zone in which the client is in (unless the Display Times in UTC feature is enabled, see below). When entering time values in ViewX, the time values you enter will be converted into UTC before they are sent to the server.

ViewX can be set to display times in UTC instead of converting them into local time. To achieve this, the Display Times in UTC option must be enabled for the User (via the Regional Settings section of the User Form and Root Group Form or via the General/Guest User section of the Tools/Options window for the Guest user.). When the Display Times in UTC setting is enabled, all times are shown and entered in UTC.







Time Zones for WebX Clients



The Time Zone setting for a WebX client is similar to that of a ViewX client except that it uses both the time zone of the client that is running the web browser and the time zone of the ClearSCADA  server to which it is connected.

For information that is shown in the ActiveX control (ViewXCtrl), the client's time zone is used. The ActiveX control is the rectangular display area in WebX that has scroll bars. For example, all Lists viewed in WebX use the client's time zone as Lists are displayed in the ActiveX control.

For information that is shown as raw HTML i.e. is not shown in the ActiveX control, the server's time zone is used. For example, the View pages for database items use the server's time zone as they are not shown within the ActiveX control.







Time Zones for ODBC Clients



When an ODBC client, for example, Crystal Reports or Excel, queries the database any times in the query or in the data returned can be in either UTC or local time. This is configured using the Local Time checkbox in the DSN setup window (see the Data Sources (ODBC) control panel applet in Windows). Local time is determined by the time zone of the client PC.

If the Local Time checkbox is ticked, the local time of the client is always used. For example, if you are using Crystal Reports on a client, and you enter a time parameter, that time parameter will always be calculated using the local time value of your client. However, if the Local Time checkbox is unticked, the time parameter will be in UTC.







Time Zones for Other Features



Various features allow the time zone in which they operate to be configured to be UTC or local time (with or without DST). Examples of such features include:

Schedules
Logic
Historic Views
Accumulators (timed report and end of period reset)




For more information, please refer to the relevant configuration section in  ClearSCADA  Help, for example, for information on configuring the time zone for Historic Views, refer to the Historic Views documentation in the Server Administration Guide.


Go: Home Back

Author

Biography

Anonymous user

Link copied. Please paste this link to share this article on your social media post.

  • Back to Blog
  • Newer Article
  • Older Article
To The Top!

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practice
  • Experts Leaderboard
  • Contact Support
Brand-Logo
Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Forum-Icon

Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account? Login

Terms & Conditions Privacy Notice Change your Cookie Settings © 2025 Schneider Electric

This is a heading

With achievable small steps, users progress and continually feel satisfaction in task accomplishment.

Usetiful Onboarding Checklist remembers the progress of every user, allowing them to take bite-sized journeys and continue where they left.

of