Magento – Get current date time used in magento for saving data

datemagento-1.9timezone

I want to get current date time which is magento used for save data into database. I searched and get this line of code,

Mage::getModel('core/date')->date('Y-m-d H:i:s');

but this is not working for me. For test i create a product and check its details then i get this date,

[created_at] => 2015-11-18 07:47:35

but after that i echo above line then date is different. I get this date after echo Mage get date line

2015-11-17 21:52:05. I want function which provides datetime which is save in database.

Best Answer

Keep in mi mind that PDO is aware of the timezone set in your Magento installation, which is most likely causing you troubles.

When you try to work with automatic timestamps, try using Mage::getModel('core/date')->gmtDate('Y-m-d H:i:s').

Related Solutions

Magento1.9 Product Date – Fix Created_at Date Format Changing

you have to use

Mage::getModel('core/date')->gmtDate()

instead of

$zendDate->getIso()

below is the solution.

open following file : app\code\core\Mage\Eav\Model\Entity\Attribute\Backend\Time\Created.php

and comment out beforeSave() function and replace with following function code.

  public function beforeSave($object)
{
    $attributeCode = $this->getAttribute()->getAttributeCode();

    $date = $object->getData($attributeCode);

    if (is_null($date)) {
        if ($object->isObjectNew()) {

            $object->setData($attributeCode, Varien_Date::now());
        }
    } else {
        // convert to UTC
        $zendDate = Mage::app()->getLocale()->utcDate(null, $date, true, $this->_getFormat($date));

        // Replace -> $zendDate->getIso() with Mage::getModel('core/date')->gmtDate()
        $object->setData($attributeCode, Mage::getModel('core/date')->gmtDate());
    }

    return $this;
}

Magento – Magento 2 – Problem with datetime attribute product

Check your database whether your column is date type or date-time type.If it is date type then it only saves date not time but if your column type is of date-time then it saves date and time both.

Best Answer

Related Solutions

Magento1.9 Product Date – Fix Created_at Date Format Changing

Magento – Magento 2 – Problem with datetime attribute product

Related Topic