4

I recently transferred servers and ever since my timestamps in Magento (both orders and help desk messages) are incorrect. I have checked all of my configuration settings, and they are correct. I have tried all of these: https://magentocookbook.wordpress.com/2010/02/15/magento-date-time/ which gave me a 404 site wide. I followed this guide to edit .htaccess: https://www.a2hosting.com/kb/developer-corner/php/using-php-directives-in-custom-htaccess-files/setting-the-php-time-zone-in-an-htaccess-file and have built the script and from what I can tell it says our timezone is correct. Any assistance as to what may be causing this sort of issue or how to fix would be appreciated!

  • incorrect by how much? Is it definitely a timezone issue or is your server's system time just wrong? If it is a timezone issue, what timezone is your server using, e.g. if you log in to SSH and just type date? – Doug McLean Nov 17 '15 at 22:05
  • @Doug McLean Our timezone is MST (Denver) and our Time Stamps are off by -7hrs. Our sever is using CST (Chicago). I apologize if this information isn't overly helpful. I would be interested in hiring someone to help assist me with this issue... – Lindsay Nov 18 '15 at 16:19
0

All times stored in Magento's database are stored in UTC, Coordinated Universal Time.

Any time date or time is encountered for display then the Timezone specified in your Admin configuration is used to convert the UTC to the Timezone specified.

Further reading:

  • Thank you Boomer, and I have read this, many times. But it does not seem to be helping me. Our issue is that we are -7hrs UTC, however, in our Magento Backend we seem to be an additional 7hrs off of that...almost as if our databases are storing the times in MST not UTC and then converting from from there (if that makes sense...) – Lindsay Nov 18 '15 at 16:25
  • I have seen some people actually change the timezone within the zend library which can result in lots of oddities for time/dates. Take a look at github.com/OpenMage/magento-mirror/blob/magento-1.9/lib/Zend/… and also check index.php for any timezone sets. Adding the timezone in .htaccess should be avoided as the php.ini should be set to the time zone relative to the hosting providers locale already. – B00MER Nov 18 '15 at 23:43
0

If you do this, what it's displays you ?

$date= Mage::getModel('core/date')->timestamp(time());
$now= date('Y-m-d h:i:s', $date);
Zend_Debug::dump($now);
  • string(19) "2017-07-27 09:33:59" and that's one hour behind what' set in Magento system=>config=>local – Haim Jul 27 '17 at 14:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.