so here’s my issue… I have a cron job that runs a script every 5 minutes to update my database automatically. My only problem is when the cron job runs let’s say at 3pm PST, the database will show that the data downloaded at 11pm (apparently GMT). So it will think any data that comes through between 3pm and 11pm is old. I resolved this issue before on my old server by setting the server time zone and mysql time to GMT.
Is there any way I can change the MySQL and server time zones or to download the data with a PST time stamp? I have already attempted to add the line SetEnv TZ GMT in .htaccess and that did not help. I’m am using a php script to run the mysql query.