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!
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.
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);