SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

Add ONe Hour to Data Return of WinCC

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...