When we are designing an app for worldwide customers, it is always a headache problem for dealing with time for customers from different countries and different time zone. It is quite easy to get confused with our server locale and how to store the time data in local server for each customers. This problem description is a little bit abstract. Please let me give you a real example to explain the problem in details and I am gonna show you several ways to handle the user date and time in database server.
Several days ago, I am developing my project “Google Translate Voice Mp3 Downloader” and redesign the database which will record the user request for each word and store the download record. Here is how my database looks like:
Read more