Help: I have a server which is having time in GMT-07.00 hours. My local time is GMT+05.30 hours. I need to get current date and time from server and convert this date and time into my local time. I have tried many codes, but still have not found a successive way of doing this. Can somebody please help me out.
string zoneId = "India Standard Time";
TimeZoneInfo tzi = TimeZoneInfo.FindSystemTimeZoneById(zoneId);
DateTime result = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, tzi);
DateTime cu = result.ToUniversalTime();
DateTime cur = cu.ToLocalTime();
I have tried all the above methods, still I'm not getting the correct answer. Suppose my current local time is 09-Mar-2014 12:51:00 PM, then my server time would be 12.30 hours different from my local time, ie subtract 12 hours and 30 minutes from my local time to get my server time. I need to get my local time from the server time. How can it be acheived?? Please suggest me some solutions.. Thanks in advance for your answers
if you want to add 12 Hours and 30 minutes to your Server time to get equavalent localtime(assuming you have server time), you can use
AddHours()
andAddMinutes()
functions to add the 12:30 hoursTry This:
The simplest way to get the UTC date and time of the server is (SELECT GETUTCDATE();). Try it.
no need to know server time zone. if the server time setting is correct you can try this :
to check it locally , change your computer timezone to match your server. then run the code. I check and it's working fine.
update:
the first two lines can be mixed into one line as below . that has a better performance :
If your server's clock is set correctly (regardless of time zone), then the first three lines of your own code are exactly correct. The
result
variable contains the local time in the India time zone.Simply omit the last two lines.
So you have the server's time, and you know the server's time zone? Then you can get the local time like this: