How to convert UTC datetime into any local client timezone

P

phuong

Hello,

I am developing a Web appplication using C# , ASP.NET.

All the datetimes stored in our database are UTC datetime.
How can I convert UTC datetime into many clientside local timezones.
and vice versa ie: to convert the local client timezone datetime back to
UTC datetime before saving it to database.

Any suggestion is very appreciated!


Thank in advance!

Phuong
 
D

devplayer04

Just a question here...

would it account for daylight savings so that we can show the local time???
 
P

phuong

Hi Martin,

Thanks for your reply. But what they tried to do in the example is not what
I want to do. That example has tried to convert datetime between the local
timezone of the SERVER machine (not the CLIENT machine) and the UTC
datetime.

What I want to do in my WEB application is let the user at the client side
enter a datetime (using calendar) Then, when the page postback to the server
side, the appplication have to know from which timezone the CLIENT is (note
that: this is a WEB app. There are a thousand of clients from the internet)
and then convert the entered datetime into UTC datetime before saving it
into database. Later when showing the UTC datetime retrieved from our
database, I want first it is converted to the local CLIENT timezone before
show it on the web UI.

Hope, that I have explained my problem clearly. If you need more info,
please feel free to ask.

Thank you very much!!!



Phuong
 
D

devplayer04

phoung as far as the client datetime is concerned, you can get the timezone
by using the following:
<script language="javascript">
function init()
{
var datNow = new Date();
/// e.g. -8 means the zone is UTC+8
/// e.g. 8 means the zone is UTC -8
/// the offset value is the value that is applied in hours to the
current datetime
/// in order to get the current UTC value
document.forms[0]["offset"].value = datNow.getTimezoneOffset();
}
</script>
<body onload="init();">
<form runat="server">
<input type="hidden" runat="server" id="offset" />
</form>
</body>

caveat
=====
1. If the client has the wrong settings, you will receive the wrong
settings.
 
P

phuong

Dear Devplayer04,

Thanks for your help. I have successfully converted from Client side
timezone datetime to UTC datetime, using getUTCDate, getUTCMonth,
getUTCFullYear, getUTCHour.....
These functions return UTC datetime with correct DAYLIGHT SAVINGS.

But I am still stuck in the reverse direction, ie. convert from UTC to any
client timezone datetime with a correct DAYLIGHT SAVING.
From the UTC offset I can get the local client datetime but I can not get a
correct datetime if it is in daylight saving period..

If you have any sugesstion, please share it with me. I am very appreciated
your help.

Thanks allot!!

Phuong


devplayer04 said:
phoung as far as the client datetime is concerned, you can get the timezone
by using the following:
<script language="javascript">
function init()
{
var datNow = new Date();
/// e.g. -8 means the zone is UTC+8
/// e.g. 8 means the zone is UTC -8
/// the offset value is the value that is applied in hours to the
current datetime
/// in order to get the current UTC value
document.forms[0]["offset"].value = datNow.getTimezoneOffset();
}
</script>
<body onload="init();">
<form runat="server">
<input type="hidden" runat="server" id="offset" />
</form>
</body>

caveat
=====
1. If the client has the wrong settings, you will receive the wrong
settings.


phuong said:
Hi Martin,

Thanks for your reply. But what they tried to do in the example is not what
I want to do. That example has tried to convert datetime between the local
timezone of the SERVER machine (not the CLIENT machine) and the UTC
datetime.

What I want to do in my WEB application is let the user at the client side
enter a datetime (using calendar) Then, when the page postback to the server
side, the appplication have to know from which timezone the CLIENT is (note
that: this is a WEB app. There are a thousand of clients from the internet)
and then convert the entered datetime into UTC datetime before saving it
into database. Later when showing the UTC datetime retrieved from our
database, I want first it is converted to the local CLIENT timezone before
show it on the web UI.

Hope, that I have explained my problem clearly. If you need more info,
please feel free to ask.

Thank you very much!!!



Phuong
Click to expand...
http://msdn.microsoft.com/library/en-us/cpguide/html/cpconformattingobjectsforspecificculture.asp
back
to
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert UTC datetime into many local timezones 7
Convert UTC DateTime to Local Time (Not My Local Time) 1
Convert stored UTC time to webuser's local time? 1
convert UTC to local time(system time) and vice vesra in VB.NET 1
Does UTC account for GMT Daylight Saving? 2
International datetime comparisons in real-time web apps 1
ISO 8601 and datetime store/retrieve from DB. 2
datacolumn datetime from UTC to Localtime 2

Top