Posted by Erland Sommarskog on 09/30/20 11:17

(thomasamillergoogle@yahoo.com) writes:
> My sql server 2000 database is on a shared server that I have
> absolutely no control over.
>
> When i run query select getdate() it is reporting the wrong time!
>
> I am pretty sure that the sql admin changed the date on the server last
> night and now this is happening.
>
> Is this possible. Shouldn't getdate() ALWAYS report back the date time
> in my LOCAL time zone?

No. getdate() will report the time in the server's time zone.

And as far as I know, getdate() follows the system time. That is, if system
time is adjusted, then getdate() follows suit.

If you have access to xp_cmdshell (since this is a shared server, I suspect
you have not), you can try:

exec master..xp_cmdshell 'time /T'

to view the system time without SQL Server in between.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: How to delete a big amount of data
• Prev in forum: Re: What is the right value for BCP's ROWS_PER_BATCH
• Thread view: Re: system time on sql server is wrong?

[Reply to this message]