| SitePoint Sponsor |
Dear All,
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.
17-29% of paid ad clicks are fraudulent. Get protected with Improvely, your online marketing dashboard.
→ Conversion tracking, click fraud detection, A/B testing and more.
Dear Dan,
Can you give me some hints on how to do it? I am not so clear is it set default-time-zone= ?
Dear Dan,
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.
Posting Permissions
Bookmarks