I have created a SharePoint application which has a specific time zone. The Windows server where SQL Server and SharePoint are installed are using same time zone.

When I create a new item in list in SharePoint it shows some different time zone time. You know the time it shows under "Modified"

I don't know why this is happening. If I query current date and time in SQL Server then it shows correct time zone but in SharePoint it is showing different times.

What could be the reason?

1 Answer 1


What is the time zone set in SharePoint Central Administration?

Go to the following link and see if the time zone matches what you expect:


Also check the regional settings for your Site Collection to see if the correct timezone is set.

  • That's strange. I set CA Application timezone to the same as my server. But when I went to regional settings page, the timezone was of different but the hours were in the same range. For e.g. if my timezone was +5 City1 then in regional settings it was +5 City2. Anyway I have changed it to +5 City2 and now I will check if it is working. Nov 4, 2013 at 10:43
  • No this change didn't solve the problem. I created a new item in list to test and it said "Create at 11/4/2013 3:03AM" when here it's actually 2:04PM Nov 4, 2013 at 11:04
  • Ok I found out that I actually had to go to Regional Settings of my site collection where the time zone was wrong. Nov 4, 2013 at 11:09
  • Cool. I have updated my answer to check for the Site Collection regional settings too. Nov 4, 2013 at 15:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.