Converting the time from one timezone to another

18 Feb 2006 7:19 AM

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.ToUniversalTime()

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.AddHours(-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.AddHours(GetTZOffset(TimeZones.EST))

Is there a function that does this, or any way to get the offset by
submitting the timezone? Thanks.

--
Nathan Sokalski
njsokal***@hotmail.com
http://www.nathansokalski.com/

18 Feb 2006 7:31 AM

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]

Show quoteHide quote

|

18 Feb 2006 8:18 AM

aweska don

Thanks

http://www.newbestweb.com owner

18 Feb 2006 5:53 PM

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
njsokal***@hotmail.com
http://www.nathansokalski.com/

Show quoteHide quote

"William Stacey [MVP]" <william.sta***@gmail.com> wrote in message
news:epuJU1FNGHA.3276@TK2MSFTNGP09.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]
> |
>
>

18 Feb 2006 11:44 PM

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]

Show quoteHide quote

23 Feb 2006 7:25 PM

Sandor Heese

have a look at this MSDN article:

Coding Best Practices Using DateTime in the .NET Framework
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/datetimecode.asp

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

Sandor

Show quoteHide quote

"Nathan Sokalski" <njsokal***@hotmail.com> wrote in message
news:OZBJ1uFNGHA.2300@TK2MSFTNGP15.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.ToUniversalTime()
>
> 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.AddHours(-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.AddHours(GetTZOffset(TimeZones.EST))
>
> Is there a function that does this, or any way to get the offset by
> submitting the timezone? Thanks.
> --
> Nathan Sokalski
> njsokal***@hotmail.com
> http://www.nathansokalski.com/
>

2 Mar 2006 4:13 PM

clintonG

Thanks so much for posting that URL Sandor...

<%= Clinton Gallagher

Show quoteHide quote

"Sandor Heese" <nospam@nospam.com> wrote in message
news:%23axbo7KOGHA.2268@TK2MSFTNGP09.phx.gbl...
> have a look at this MSDN article:
>
> Coding Best Practices Using DateTime in the .NET Framework
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/datetimecode.asp
>
> it contains a lot of info about how to convert between timezones etc.
>
> Sandor
>
> "Nathan Sokalski" <njsokal***@hotmail.com> wrote in message
> news:OZBJ1uFNGHA.2300@TK2MSFTNGP15.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.ToUniversalTime()
>>
>> 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.AddHours(-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.AddHours(GetTZOffset(TimeZones.EST))
>>
>> Is there a function that does this, or any way to get the offset by
>> submitting the timezone? Thanks.
>> --
>> Nathan Sokalski
>> njsokal***@hotmail.com
>> http://www.nathansokalski.com/
>>
>
>

Thread options