Developing a web application which should allow User to schedule appointment based on their TimeZone. And I am storing the User scheduled datetime as server datetime into database field.  While showing schedule information retrieved the value from Database and converted into user timzone. processing in Code base I am converting the DateTime based on the user timezone. Please suggest is this best practice or any easy way is exist?
Best practice to store DateTime based on TimeZone
c#;asp.net;code reviews
Welcome to one of the hardest problems in non-computational programming - properly representing dates and times to end users.Realistically, timestamps should be stored in a fixed single representation regardless of how they will be interpreted, because no matter how hard you try, you will always have ambiguous cases, and you can't resolve them without a fixed representation.  And you've picked one of the worst of the use cases - scheduling an appointment.  The only worse common use case is air travel, where a trip might start in one time zone and end in another, possible at an earlier local time.Always, always, ALWAYS store in UTC and display in the user's preferred or explicitly specified timezone.  If at all possible, make the user tell you what timezone they believe the timestamp to be in when they input it (e.g., have an explicit timezone field and pre-populate it with their preferred zone).