Converting the time from one timezone to another

[Nathan Sokalski]

I asked a question about a week ago about how to get my local time, since my
application is running on a server halfway around the world. I have
determined that my code would look something like this:

Dim servertime As Date = Date.Now

Dim utctime As Date = servertime.ToUn iversalTime()

Dim localtime As Date
I know that the last step would be to adjust the utctime value by the
appropriate amount using code such as utctime.AddHour s(-5), but I am looking
for a way to get this value by supplying the timezone rather than an offset
(in other words, I am looking for a function that returns either a
System.TimeSpan or Integer when I enter the timezone) so that I can do
something such as

utctime.AddHour s(GetTZOffset(T imeZones.EST))

Is there a function that does this, or any way to get the offset by
submitting the timezone? Thanks.
--
Nathan Sokalski
nj********@hotm ail.com
http://www.nathansokalski.com/

[William Stacey [MVP]]

See my UTC project for sql. It has the c# class you need.
http://channel9.msdn.com/ShowPost.aspx?PostID=142586

--
William Stacey [MVP]
|

[Nathan Sokalski]

I could not find any code or links to download code on the page you gave a
link to. Also, even though I will be using the code for SQL in some cases,
my goal is to generate a System.DateTime object that is the local time. If I
am missing the code, please let me know exactly where on your page it is.
Thanks.
--
Nathan Sokalski
nj********@hotm ail.com
http://www.nathansokalski.com/

"William Stacey [MVP]" <wi************ @gmail.com> wrote in message
news:ep******** ******@TK2MSFTN GP09.phx.gbl...

See my UTC project for sql. It has the c# class you need.
http://channel9.msdn.com/ShowPost.aspx?PostID=142586

--
William Stacey [MVP]
|

[William Stacey [MVP]]

There is a "Save" link at the bottom of the article. Easy to miss. The
APIs get and return DateTime, so you should be ok. Can use with sql or
without. Let me know if you still have problems.

--
William Stacey [MVP]

"Nathan Sokalski" <nj********@hot mail.com> wrote in message
news:%2******** *******@TK2MSFT NGP10.phx.gbl.. .
|I could not find any code or links to download code on the page you gave a
| link to. Also, even though I will be using the code for SQL in some cases,
| my goal is to generate a System.DateTime object that is the local time. If
I
| am missing the code, please let me know exactly where on your page it is.
| Thanks.
| --
| Nathan Sokalski
| nj********@hotm ail.com
| http://www.nathansokalski.com/
|
| "William Stacey [MVP]" <wi************ @gmail.com> wrote in message
| news:ep******** ******@TK2MSFTN GP09.phx.gbl...
| > See my UTC project for sql. It has the c# class you need.
| > http://channel9.msdn.com/ShowPost.aspx?PostID=142586
| >
| > --
| > William Stacey [MVP]
| > |
| >
| >
|
|

[Sandor Heese]

have a look at this MSDN article:

Coding Best Practices Using DateTime in the .NET Framework
http://msdn.microsoft.com/library/de...tetimecode.asp

it contains a lot of info about how to convert between timezones etc.

Sandor

"Nathan Sokalski" <nj********@hot mail.com> wrote in message
news:OZ******** ******@TK2MSFTN GP15.phx.gbl...

I asked a question about a week ago about how to get my local time, since
my application is running on a server halfway around the world. I have
determined that my code would look something like this:

Dim servertime As Date = Date.Now

Dim utctime As Date = servertime.ToUn iversalTime()

Dim localtime As Date
I know that the last step would be to adjust the utctime value by the
appropriate amount using code such as utctime.AddHour s(-5), but I am
looking for a way to get this value by supplying the timezone rather than
an offset (in other words, I am looking for a function that returns either
a System.TimeSpan or Integer when I enter the timezone) so that I can do
something such as

utctime.AddHour s(GetTZOffset(T imeZones.EST))

Is there a function that does this, or any way to get the offset by
submitting the timezone? Thanks.
--
Nathan Sokalski
nj********@hotm ail.com
http://www.nathansokalski.com/

[clintonG]

Thanks so much for posting that URL Sandor...

<%= Clinton Gallagher

"Sandor Heese" <no****@nospam. com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

have a look at this MSDN article:

Coding Best Practices Using DateTime in the .NET Framework
http://msdn.microsoft.com/library/de...tetimecode.asp

it contains a lot of info about how to convert between timezones etc.

Sandor

"Nathan Sokalski" <nj********@hot mail.com> wrote in message
news:OZ******** ******@TK2MSFTN GP15.phx.gbl...

I asked a question about a week ago about how to get my local time, since
my application is running on a server halfway around the world. I have
determined that my code would look something like this:

Dim servertime As Date = Date.Now

Dim utctime As Date = servertime.ToUn iversalTime()

Dim localtime As Date
I know that the last step would be to adjust the utctime value by the
appropriate amount using code such as utctime.AddHour s(-5), but I am
looking for a way to get this value by supplying the timezone rather than
an offset (in other words, I am looking for a function that returns
either a System.TimeSpan or Integer when I enter the timezone) so that I
can do something such as

utctime.AddHour s(GetTZOffset(T imeZones.EST))

Is there a function that does this, or any way to get the offset by
submitting the timezone? Thanks.
--
Nathan Sokalski
nj********@hotm ail.com
http://www.nathansokalski.com/