|
The time on the transactions that are entered into my SQL DB from PA File Sight are incorrect, the time is off by approximately 1 hour. The time on the computer that is hosting the SQL is correct. How can I correct the time? |
|
Hi Bill, Thanks for the question. The PA File Sight service collects the time from the server that it is monitoring using UTC time and then records that time in the database. If you are an hour off I would suggest that you check the time on the server that is being monitored. Another thing to check is are there any time zones changes based on where your servers are at. Thanks Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer. |
|
Bill, The database stores timestamps in UTC as that's considered a best practice (storing local times causes trouble when a daylight savings change happens). If you are running reports from the SQL database you will need to adjust for the difference in time. Thanks Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer. |