August 22, 2020 at 4:19 pm
Hello, I have SQL Server 2019 installed on a server with windows server 2019, in the operating system the time is 11:10 am but in SQL Server when I give it SELECT GETDATE () it brings 10:10, I don't know what else to check.
many of the stored procedures use getdate () and obviously this is affecting my processes
August 23, 2020 at 5:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
August 24, 2020 at 7:12 am
Server time can be different from client time. GETDATE() returns the server time, not what you see on your client.
You will need to ensure that your servers are set in the right date/time zone in control panel. I guess your servers are set for a default of UTC time, but your client is set for GMT/BST or some other time zones where they are 1 hour apart.
Probably worth speaking to your Windows Admins to find out the server default time zone across the WHOLE server estate as they should ideally match. Generally everywhere I work its set in UTC time in all data centres across the world so that there is no ambiguity and then use time zone offsets to get the actual users time zone for calculations.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply