Magento – How to set Local Timezone when saving time into DB in Magento

magento-1.9timetimezone

I have applied following things to make Default time zone to my local timezone i.e. 'Asia/Calcutta' —

1) changed in config.xml –

<general>
            <locale>
                <code>en_US</code>
                <timezone>Asia/Calcutta</timezone>
            </locale>
 </general>

2) Changed in Mage.php –

 if (is_readable($localConfigFile)) {
                $localConfig = simplexml_load_file($localConfigFile);
                date_default_timezone_set('Asia/Calcutta');
                if (($date = $localConfig->global->install->date) && strtotime($date)) {
                    self::$_isInstalled = true;
                }
  }

Now when I am trying to insert any time in db using this code

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

it does not work according to current timezone and saves 5:30 hours ahead date in DB. can anyone tell me how can I do it or Have I done something wrong in default timezone settings.

Best Answer

I believe what you need to do it go to System > Configuration > General > General > Localization options and change the default timezone to "India Standard Time" then Save.
I think this is what prevents you from having the right time saved in the DB.

Related Solutions

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

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').

Magento – How to change Magento timezone

You can set timezone from Admin panel ,

Go to :

System => Configuration => General => Locale Options =>Timezone

AND

Change the default timezon in file app/Mage.php

date_default_timezone_set('UTC');

Replace above line with following

date_default_timezone_set('Asia/Calcutta');

AND

Copy file app/code/core/Mage/Core/Model/Locale.php to app/code/local/Mage/Core/Model/Locale.php then find line 38

const DEFAULT_TIMEZONE = 'UTC';

Replace above line with following

const DEFAULT_TIMEZONE = 'Asia/Calcutta';

Note: If still it will not work. Dig in to following function in app/code/local/Mage/Core/Model/Locale.php.

public function storeDate($store=null, $date=null, $includeTime=false, $format = null)
    {
        $timezone = Mage::app()->getStore($store)->getConfig(self::XML_PATH_DEFAULT_TIMEZONE);
        $date = new Zend_Date($date, $format, $this->getLocale());
        $date->setTimezone($timezone);
        if (!$includeTime) {
            $date->setHour(0)
                ->setMinute(0)
                ->setSecond(0);
        }
        return $date;
    }

Hope this helps

Best Answer

Related Solutions

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

Magento – How to change Magento timezone

Related Topic