newtomysql — 2010-02-26T02:30:01-05:00 — #1
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.
dan_grossman — 2010-02-26T02:47:35-05:00 — #2
Choose a time zone, and convert all dates to that time zone before storing them.
newtomysql — 2010-02-26T07:52:47-05:00 — #3
Can you give me some hints on how to do it? I am not so clear is it set default-time-zone= ?
newtomysql — 2010-02-26T08:38:41-05:00 — #4
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.