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?

asked 18 Nov '15, 12:24

Bill's gravatar image

Bill
011
accept rate: 0%


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
Quinn

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.

link

answered 18 Nov '15, 17:30

Quinn's gravatar image

Quinn ♦♦
14.4k3925
accept rate: 35%

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
Quinn

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.

link

answered 18 Nov '15, 14:53

Quinn's gravatar image

Quinn ♦♦
14.4k3925
accept rate: 35%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×37
×3

Asked: 18 Nov '15, 12:24

Seen: 3,704 times

Last updated: 18 Nov '15, 17:30