错误的博客发布日期显示在Magento

Question

我在magento的前端发现错误的博客发布日期。

这是我的帖子的phtml文件的代码。

$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); 

，并在下面HTML它显示日期一样 -

<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> 

这是我的数据库结构

+--------------------+----------------------+------+-----+---------------------+-----------------------------+ 
| 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    |        | 
+--------------------+----------------------+------+-----+---------------------+-----------------------------+ 

谁能帮我找到什么是错，此代码。 在数据库中显示正确的日期。

Answer 1

有两件事你必须

先上更新CURRENT_TIMESTAMP删除此所以，如果你想要做的Magento方式的日期将不会更新

使用此为created_At Varien_Date::now()设定值。

<?php $date=Mage::app()->getLocale()->date($date); 
     echo date('L d, M Y',strtotime($date)) ?>