Results 1 to 5 of 5

Thread: TimeZones

  1. Nov 5th, 2007, 11:59 AM #1
    sinha
    sinha is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2002
    Location
    Malaysia
    Posts
    345

    TimeZones

    Hi!

    The users of my application span in diffrent countries. I am displaying couple of DateTime infos on a Grid, with NYC time (thats what stored in the database). But, they want to view those info, according to their Time Zones. How to accomplish this?

    Thanks.
    Thanks.
    Reply With Quote Reply With Quote
  2. Nov 5th, 2007, 08:58 PM #2
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    Re: TimeZones

    The simple fact is that if you want use data in multiple time zones then it should be stored as UTC. You can then convert it to local time at each individual location.

    .NET has no specific support for time zones other than to be able to convert between UTC and local time. There's no in-built way to switch to a specific time zone, so you're just going to have to perform a manual calculation. Someone created a TimeZoneInfo class and posted in the VB.NET CodeBank forum. You may find that helpful in that regard.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
  3. Nov 7th, 2007, 03:05 PM #3
    sinha
    sinha is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2002
    Location
    Malaysia
    Posts
    345

    Re: TimeZones

    Thanks
    Thanks.
    Reply With Quote Reply With Quote
  4. Nov 7th, 2007, 10:59 PM #4
    popskie
    popskie is offline
    Fanatic Member popskie's Avatar
    Join Date
    Jul 2005
    Location
    In my chair
    Posts
    666

    Re: TimeZones

    If Im not wrong it could be posible in .net 3.5
    http://docs.msdnaa.net/ark_new3.0/cd...plications.htm

    W3School C# Impersonation Screen Capture Bohol Dictionary MSDN Search Engine C# Port Programming
    Creating sharepoint web part using C# Active directory
    Reply With Quote Reply With Quote
  6. Nov 8th, 2007, 12:17 AM #5
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    Re: TimeZones

    Quote Originally Posted by popskie
    If Im not wrong it could be posible in .net 3.5
    I just had a quick look and there is indeed a TimeZoneInfo class in .NET 3.5. I'm guessing that VBDT's CodeBank submission mimics that.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width