I am building an application where it will store data locally and at some interval the data will be updated to a central database. So what I worried is about the date time information which I store. I find that now if I change my local time then it takes that time. How can I ensure that throught all my client the data time is following one standard? Thank you.
Choose a time zone, and convert all dates to that time zone before storing them.
Can you give me some hints on how to do it? I am not so clear is it set default-time-zone= ?
Ok I have set into my ini file default-time-zone = '+08:00' but when I change my pc time and when I do SELECT NOW(); it gives me the time as according to my pc time changes. Thank you.