-1

Lets suppose, if a user from India enters some data into the database with its own local timestamp at 5:30 a.m and at the same time a user from U.S.A want to see the data, at that time he will feel very weird because that time which is entered in the database has not arrived yet. How to handle this problem ?

Praveen_Shukla
  • 1,324
  • 14
  • 20
  • 1
    Possible duplicate of [Daylight saving time and time zone best practices](http://stackoverflow.com/questions/2532729/daylight-saving-time-and-time-zone-best-practices) – Matt Johnson-Pint Oct 06 '15 at 17:54

1 Answers1

1

Store all dates and times as UTC date and time values and convert them to the local date and time whenever they are displayed.

Mike Feltman
  • 5,160
  • 1
  • 17
  • 38