DatePicker local time VS. server time

Permanently deleted user

January 15, 2018 14:30

Hi, DatePicker returns local time. Our Geocortex server time zone is Eastern time (UTC-5). If a user is located in Atlantic Time zone (UTC-4), when the user selects a date for example (2018/Jan/20 12:00PM), on the server it's converted to 2018/Jan/19 11:00PM. The "Day" value changed from "20" to "19". The date value is very important for us. We don't care about the time value. How to make sure that Geocortex server uses the Date that users selected from DataPicker? In another words, how to convert the local time selected from DatePIcker to the server time zone?

Thanks

0

• 

  Permanently deleted user

  January 15, 2018 15:06

  Rose, I found it best to store date in the database as UTC without timezone offset. This way, the time in your database will always be UTC and the clients can handle converting the date to the user's local date, which it does automatically.

  0
• 

  Permanently deleted user

  January 15, 2018 17:26

  Thanks Carlos for your reply. I will give it a try.

  Rose

  0

Please sign in to leave a comment.