Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have Windows Server 2008 and SQL Server 2008 R2.

When I get date with SELECT GETDATE() from SQL Server, it shows the current date and time, but with 6 minutes less than Windows server watch (time) .

I checked location, time and Active Directory but I don't understand why my SQL Server GetDate function returns 6 minutes difference compared to my Windows server time.

Can anybody help me ?

share|improve this question
My guess: you are running Management Studio on your local machine but connecting to an instance on another machine. –  Aaron Bertrand Sep 11 '13 at 13:49

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.