Siemens Industry Online Support - Automation Service, Automation Support, Simatic Service, Simatic Support, Technical Support, Technical Consulting

WinCC -- Configuring Tag Logging -- Displaying Tag Logging

	How do you calculate the difference between local time and UTC time in WinCC and how do you convert UTC time into an SQL statement?
	Displaying and exporting alarms and tag values on a Dat@View client with Windows NT 4.0
	What does the SIMATIC WinCC/DataMonitor options package contain?
	How can you display archives of other WinCC projects in Runtime?
	How can you create a database user in the WinCC Runtime database for access via the MS OLE DB provider?
	How can you access archived WinCC data with a C# Windows application?
	How can you convert a time stamp (date and time) of the local computer time into coordinated world time (UTC)?
	What options are there in WinCC for read and write access to TagLogging/AlarmLogging archives?

How do you calculate the difference between local time and UTC time in WinCC and how do you convert UTC time into an SQL statement?

Part number:

Instructions
The data of WinCC archives is stored with a UTC time stamp.
Attached is an example created WinCC V6.0 SP3 in VB for:

Calculating the difference between local time and UTC time
Outputting local time and UTC time
Converting UTC time into an SQL statement

Brief description of the project
The project contains a picture with three buttons (yellow). The buttons trigger the various VB actions, the results are output in the I/O fields underneath.

Note
More information about handling times in WinCC is available in Entry ID: 26729255.

Screenshot of the project

Fig. 01