| Erland Sommarskog 2005-05-29, 1:23 pm |
| (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/techin.../2000/books.asp
|