How to get Server Date and Time

Question

1.00/5 (2 votes)

See more:

Hi,

I have a winform which is created in vs2010.
Here I want to display server date and time.

But Time in running Mode just like clock.

I have window Dedicated Server with mssql install.

I get the date and time when form is load but i want to continus display time in running just like a system time.

But If i use timer and add 1 seconds on every tick its time we will be increase from current server time approx 2-3 min after some time.

I want to real update time from server. But I do not want to exqute sql query per second to get time. its create a big problem for me..

Please suggest me that I want to make a real clock on client machine
means machine and server time are little bit same.

thanks
Ram Kumar

Posted 17-Nov-14 6:12am

Ram Kumar(Webunitech)

Add a Solution

Comments

ZurdoDev 17-Nov-14 12:34pm

You want the server time but don't want to execute sql to get it?

BillWoodruff 17-Nov-14 12:35pm

Why don't you synchronize your local machine's time-setting with the server every some-number-of-minutes ? They are not likely to get out of synch in a time-frame of minutes.

Maciej Los 17-Nov-14 13:31pm

Why? Why? and Why?

2 solutions

Solution 2

Try these..

Get current date time from server and convert it into local time in c#

C#

DateTime serverTime = DateTime.Now; // gives you current Time in server timeZone
DateTime utcTime = serverTime.ToUniversalTime; // convert it to Utc using timezone setting of server computer

TimeZoneInfo tzi = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
DateTime localTime = TimeZoneInfo.ConvertTimeFromUtc(utcTime, tzi); // convert from utc to local

to check it locally , change your computer timezone to match your server. then run the code. I check and it's working fine.
the first two lines can be mixed into one line as below . that has a better performance :

C#

DateTime utcTime = DateTime.UtcNow;

Or See this links.

Link1[^]

Link2[^]

Posted 17-Nov-14 9:09am

/\jmot

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2014-11-17T08:49:00

You can't get any information from SQL server unless you ask for it: and a SELECT query is pretty much the only way to do that. So try:

SQL

SELECT GETDATE()

But please, don't do it per second!
Why not just read it once when you app starts, and store it as:

C#

DateTime serverTime = GetDateAndTimeFromSQL();
TimeSpan serverDiff = DateTime.Now - serverTime;

You can then use the TimeSpan value to work out what the server time is by adding the difference onto the current date and time for your machine. A re-check every couple of hours should keep them nicely in sync.