AnsweredAssumed Answered

DST Issue

Question asked by Rashmi on Feb 19, 2016
Latest reply on Feb 25, 2016 by gregor



Please can anyone advise on the below scenario with regards to DST issue?


1. PI data gets created on SMT, which is on UK server

2. My script (PowerShell) runs on US server to fetch the data from UK server (PI SMT tool)

3. the time difference between US and UK is now 6hrs gap (US is ahead of UK)

4. When I run the script today (19th feb), the file name gets printed as 18th Feb 000000 and the 2nd file name will be 19th feb 001000, 3rd file 19th feb 00300 and so on till 235000 timestamp (as per the code written inside powershell script)

5. 18th feb 000000 file contains the attribute values of 11th feb 18PM data on UK server (since time gap is 6 hrs) and the next file value map to 610,6:20 and so on.(as per timestamp variable inside the sql query).


6. Now the DST is going to change on 13th March 2016 for US server. The clock will forward 1 hr at 2 AM night, hence it will display as 3 AM.


My doubts.


I underrated that time difference will be 7 hrs after 13th March although, I have to handle 2 scenarios here on 13th March.


1. SInce the file name is printing as back date 000000 ,001000,002000  etc. when the DST will change on 13th, I think from 12 AM to 2 AM, the file names willbe printed as normal. but what will be the file name after 2 AM. At what exact time stamp it will print after 2 AM. when the script will run on 14th March?

2. after 2 AM, which timestamp data it will pick up from UK server or there will be no impact here since the DST on UK server is going to change on 27th March?


Please advise.


PS: $timeStamp = [DateTime]::Today.AddDays(-1)  -   this logic is for file name to generate

$timestamp1 = [DateTime]::Today.AddDays(-1).AddHours(-6),   -  this varibale i pass inside the sql query to fetch the data from PI SMT (UK server)