Change SQL Time

Question

Change SQL Time

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

sgmunson SSC Guru Points: 110640 More actions · Answer 1

Also, I would never verify anything on a server via Terminal Server. Log on locally directly on the server, or at least use Remote Desktop to do so. It's the only way to be sure TS doesn't somehow intervene. Been there and had more than a few "odd" events.

Steve

(aka smunson)

:):):)

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

Ewan Hampson SSCrazy Points: 2780 More actions · Answer 2

jjssilva (10/10/2008)
I checked all the other servers including the Database server because they are all on the same Domain, this means these servers are synchronized.

I cannot say anything about Active Directory, but just joining a server to a domain does not (as far as I know) do anything to synchronize the time settings. TimeSync is a separate service to be configured. So your server could be a bit adrift.

George Silva Ten Centuries Points: 1327 More actions · Answer 3

GilaMonster (10/13/2008)
Please run the following and see what you get.
SELECT getdate()
EXEC master..xp_cmdshell 'DATE /T'
EXEC master..xp_cmdshell 'TIME /T'

This is what I got today at 18:48 local time (same as the server time).

2008-10-18 11:48:07.093

Sat 10/18/2008

NULL

11:48 AM

NULL

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

jjssilva (10/18/2008)
This is what I got today at 18:48 local time (same as the server time).
2008-10-18 11:48:07.093
Sat 10/18/2008
NULL
11:48 AM
NULL

That's showing that both SQL and the OS think that the time is 11:48 (xp_cmdshell calls out to the OS and DATE and TIME are DOS commands). The problem isn't with SQL, the problem is that the OS has the time wrong and SQL gets its time from the OS.

It could be a time zone setting that's wrong, since the OS time is 7 hours (exactly) wrong. Can you log in to that server using the same windows account as the SQL Server service is using and see what the regional settings are for that account?

Is it possible for you to log in from the terminal or using Remote Desktop rather than Terminal Services?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

George Silva Ten Centuries Points: 1327 More actions · Answer 5

Thanks for your help.

I logged in to the server from the console instead of a Terminal Server and there it was, timezone set to US Time.

Everything is OK now.

Cheers! 😎

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 6

Thanks for the update, you had us stumped. I've only been able to change the OS time and have SQL lag by about 5-10sec at the max before it catches on.

amjad_bl_1051982 Grasshopper Points: 17 More actions · Answer 7

dear

i need some help please

im using sql server 2008 and the time on my server is in 12 hours format (i mean PM and AM format). but in the database its 24 hours format (like 13:00)

and this is making problem with my report in the web application i have ..

can any one help me please ..

thanks in advance ..