I am getting wrong blog post date on frontend in magento.
This is my code from phtml file of post.
$formatType = Mage::getStoreConfig(NeoTheme_Blog_Helper_Data::XPATH_CONFIG_DATETIME_FORMAT_TYPE);
$format = ($formatType != 'custom')?
Mage::app()->getLocale()->getDateTimeFormat($formatType):
Mage::getStoreConfig(NeoTheme_Blog_Helper_Data::XPATH_CONFIG_DATETIME_CUSTOM_FORMAT);
and in below html it display date like -
<span class="post-time">
<?php //echo $this->__('Posted On: '); ?>
<?php $date = ($this->getPost()->getPostDate() != NULL)? $this->getPost()->getPostDate() : $this->getPost()->getCreatedAt(); ?>
<?php echo Mage::app()->getLocale()->date($date)->toString($format); ?>
<?php // $timestamp = (int) Mage::app()->getLocale()->date($date)->getTimestamp() ;?>
<?php // echo date('d D', $timestamp)?><?php // echo date('M', $timestamp)?>
</span>
This is my Database structure
+--------------------+----------------------+------+-----+---------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+----------------------+------+-----+---------------------+-----------------------------+
| entity_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| created_at | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| updated_at | timestamp | NO | | 0000-00-00 00:00:00 | |
| status | smallint(5) unsigned | NO | | 1 | |
| title | text | NO | | NULL | |
| author | text | NO | | NULL | |
| post_date | timestamp | NO | | 0000-00-00 00:00:00 | |
| summary | text | NO | | NULL | |
| content_html | text | NO | | NULL | |
| meta_description | text | YES | | NULL | |
| meta_title | text | YES | | NULL | |
| meta_keywords | text | YES | | NULL | |
| store_ids | text | NO | | NULL | |
| category_ids | text | NO | | NULL | |
| tag_ids | text | NO | | NULL | |
| cms_identifier | varchar(255) | YES | UNI | NULL | |
| customer_group_ids | text | YES | | NULL | |
| publish_date | timestamp | YES | | NULL | |
| use_summary | smallint(6) | YES | | 1 | |
| root_template | varchar(255) | YES | | NULL | |
| layout_update_xml | text | YES | | NULL | |
+--------------------+----------------------+------+-----+---------------------+-----------------------------+
can anyone please help me to find whats wrong with this code. In Database it shows correct date.
there are two thing you have to
first remove on update CURRENT_TIMESTAMP this so the date will not update
use this to set value for created_At Varien_Date::now() if you want to do magento way.
<?php $date=Mage::app()->getLocale()->date($date);
echo date('L d, M Y',strtotime($date)) ?>