Using the specific timezone instead of the server timezone

Question

0.00/5 (No votes)

See more:

C#

 DateTimeOffset serverTime = DateTimeOffset.Now;

               DateTimeOffset localTime = TimeZoneInfo.ConvertTime(serverTime, TimeZoneInfo.FindSystemTimeZoneById("Singapore Standard Time"));


if (localTime.Date >= eddate.Date && localTime.Date <= stdate.Date)
               {
                   if (localTime >= sttime && localTime <= edtime)
                   {

                       MySqlConnection MyConn2 = new MySqlConnection(MyConnection2);
                       MySqlCommand MyCommand2 = new MySqlCommand(query, MyConn2);
                       MySqlDataReader MyReader2;
                       MyConn2.Open();
                       MyReader2 = MyCommand2.ExecuteReader();
                       Label2.Text = "Thank you for You Vote";
                       //  System.Diagnostics.Debug.WriteLine();

                   }
                   else
                   {
                       Label2.Text = "Please check the eletion time!";
                       Label2.ForeColor = System.Drawing.Color.Yellow;
                   }
               }
               else
               {
                   Label2.Text = "Please check the eletion date !";
                   Label2.ForeColor = System.Drawing.Color.Purple;
               }

What I have tried:

I'm trying to get the date in the timezone that I specified(Singapore Standard Time) and compare it with the date I displayed in gridview. I'm able to use the Singapore Standard Time when validating the time. However, for the date, It still not able to get the date in Singapore Standard Time.

Posted 12-Nov-20 5:47am

ycwong99

Updated 12-Nov-20 10:29am

v5

Add a Solution

3 solutions

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)

Gerry Schmitz · Answer 1 · 2020-11-12T07:13:00

Solution 1

Singapore and China are both in the same time zone. +8 GMT

Posted 12-Nov-20 7:13am

Gerry Schmitz

Comments

ycwong99 12-Nov-20 13:14pm

Hi, I'm actually made a mistake. I'm aware that they are using the same timezone, I'd like to get the current date in the Singapore Standard timezone.

[no name] 12-Nov-20 13:40pm

"Local time" is the server time. It's not the same as "client (local) computer time" if you're accessing from another time zone. The server needs the client's offset or time to do what you seem to be implying. Windows clients sync their clocks based on location; cross a time zone and they'll flip, sending field personnel into confusion when they forget that point.

ycwong99 12-Nov-20 13:49pm

Hi, I had updated my code using the offset. How can I get the date of the Singapore Standard Time?

Vincent Maverick Durano · Answer 2 · 2020-11-12T10:25:00

Solution 2

Your if-condition seems to be off. Try changing it to this:

C#

if (localTime.Date >= stdate.Date && localTime.Date <= eddate.Date){
  //Do stuff here
}

What has changed in the preceding code is switched the enddate and eddate for comparing.

Posted 12-Nov-20 10:25am

Vincent Maverick Durano

Updated 12-Nov-20 10:40am

v2

Dave Kreskowiak · Answer 3 · 2020-11-12T10:29:00

You shouldn't be screwing around with time zones.

If you're going to have a server in one time zone and a client in another, ALL datetimes should be converted to UTC before being sent between client and server. ALL datetimes should be stored in your database in UTC.

When data is displayed, that's when you convert from UTC to the local time zone. When data is entered, you convert the input datetime to UTC before sending it anywhere.

This way, every machine takes using the "universal" time zone.