How to convert UTC time to local time.

Question

0.00/5 (No votes)

See more:

, +

when I retrieve it by using .Tolocal() , it returns server local time, not client time. I save my DateTime column after converting it into UTC.

solution required for
utc time to client local time instead of server local time

What I have tried:

<asp:templatefield>
<itemtemplate>
<asp:label runat="server" id="message1" fontstyle="Georgia"
="" text="<%# Eval("username") +":" + " " + " " + " " +" " + " " + Convert.ToDateTime(Eval("Date")).ToLocalTime()%>" font-bold="True" font-italic="True">
<asp:label runat="server" id="message" htmlencode="false"
="" text="<%# Eval("message").ToString().Replace("\n", "<br/>") %>">

<controlstyle width="670px">
<headerstyle backcolor="#6699FF">
<itemstyle width="670px">

Posted 11-Apr-20 18:02pm

Member 14192879

Updated 11-Apr-20 22:40pm

Add a Solution

1 solution

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)

Richard MacCutchan · Answer 1 · 2020-04-11T22:41:00

Solution 1

Of course it converts to server local, since the code runs on the server. You need to capture the client's timezone in the browser code, and pass that to the server, or use the Javascript functions: JavaScript Date Reference[^].

Posted 11-Apr-20 22:41pm

Richard MacCutchan

Comments

Member 14192879 12-Apr-20 4:47am

var now = new Date("January 02, 2012 22: 00: 00 GMT + 0530");
var nowUtc = new Date(now.getTime() + (now.getTimezoneOffset() * 60000));
var nowmillis = now.getTime() + (now.getTimezoneOffset() * 60000);
var nowutcmillis = nowUtc.getTime() + (nowUtc.getTimezoneOffset() * 60000);
var backnow = now.setTime(millis - (now.getTimezoneOffset() * 60000));
var backutc = nowUtc.setTime(millis - (nowUtc.getTimezoneOffset() * 60000));
document.getElementById("demo3").innerHTML = now;

I used this code to retrieve date to localtime and it works well

but I do not know how I can do this gridview date

Richard MacCutchan 12-Apr-20 4:51am

Why not pass the GMT offset value back to the server? That way it can handle any time zone.

Member 14192879 12-Apr-20 5:17am

yes I saved date into the database in GMT Format

I want to know how I can pass this javascript on eval("date")

how can I pass this GMT offset to grid view?

Richard MacCutchan 12-Apr-20 5:32am

Sorry I have not used ASP grid view controls. I suggest you check the documentation to see what properties and methods are available.