Date Timeshift
-
I have an issue with date timeshifting. My site uses a database with an admin page for entering records, and a user page for querying those records.
I am in central timezone, so UTC-5. (America/Chicago)
Starting at 7:00pm local central time, all records entered into the database get entered as “yesterday”. So if I entered a record at 7:01pm central time on 9/1, it would go in the database as 8/31.
Subsequently if a user queries the database, and their start date is 8/31 and end date is 8/31, the results will be 8/30.
This corrects itself at 5:01 am UTC time (that is 12:01am local central time)
I can’t check the ‘Sync php Timezone’ option in PDB, because it causes a date shift of day+1 for expiration dates of subscriptions using the Restrict Content Pro (RCP) plugin. Meaning a subscription expiration normally of 9/1 will show up as 9/2 in RCP. Unchecking the ‘Sync php Timezone’ option fixes this in the RCP plugin.
I also can’t set the PHP default timezone because I’m on a shared server with GoDaddy and they don’t allow it.
Any suggestions, or has anyone seen anything like this?
Thanks!
The topic ‘Date Timeshift’ is closed to new replies.