Need Suggestions to manage the different country time Zone

• Saravanan_tvr

  SSCarpal Tunnel

  Points: 4558

  More actions

  October 12, 2012 at 3:09 am

  #263865

  Dear All

  We are developing one product, Its going to implements in US Cloud server, But the customers are going to use from different Regions (I.e,), one customer from Australia ,India and US on single database, In this situations in my database how can I manage and makes corrected data entries customer wise... How can we store the data and date details in to table. and shows them their zone date wise....

• PiMané

  SSChampion

  Points: 13965

  More actions

  October 12, 2012 at 5:03 am

  #1548551

  The best to do is store in the database the UTC (Universal time).

  Then the app has to convert the UTC to the users timezone.

  Check this link on how to do it in c# http://www.dotnetperls.com/timezone.

  Pedro

  ---

  
  If you need to work better, try working less...