Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Add ONe Hour to Data Return of WinCC

Created by: David_Suarez at: 12/13/2007 10:17 AM (2 Replies)

Rating (1)

Thanks 0

3 Entries

12/13/2007 10:17 AM	Rate (0)
David_Suarez Posts: 10 Rating: (0)	Hi. I want to add one hour to the data return by the SQL DataBase in WinCC to match with the local hour, can anyone help me? I suposse i need to modify the code here but I don't know how to do. [code]If( n < nRec ) Then SplitDateTimeAndMs oRS.Fields(1).Value, strDateTime, iMs s = FormatDateTime(strDateTime,2) & " " & FormatDateTime(strDateTime,3) Set oItem = oList.ListItems.Add() oItem.Text = s oItem.SubItems(1) = iMs oItem.SubItems(2) = FormatNumber(V, 4) oItem.SubItems(3) = Hex(oRs.Fields(4).Value) ' vrati End If oRs.MoveNext[/code] Thanks
David_Suarez Posts: 10 Rating: (0)
Suggestion To thank Quote Answer

12/21/2007 10:43 AM	Rate (1)
April Posts: 1776 Rating: (95)	Hi, maybe this FAQs helps http://support.automation.siemens.com/WW/view/en/26729255 http://support.automation.siemens.com/WW/view/en/22115636 April
April Posts: 1776 Rating: (95)
Suggestion To thank Quote Answer

12/21/2007 12:23 PM	Rate (0)
David_Suarez Posts: 10 Rating: (0)	Hi Very Useful, with this i solve the problem. Thanks
David_Suarez Posts: 10 Rating: (0)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on