1、先到MySQL创建一个表时间的字段为DATETIME
例如
CREATE TABLE IF NOT EXISTS `mydoop_data`.`news` (
`news_id` int(11) NOT NULL AUTO_INCREMENT,
`news_title` text NOT NULL,
`news_text` text NOT NULL,
`news_time` DATETIME NOT NULL,/*注意这行*/
`user_id` bigint(20) NOT NULL,
PRIMARY KEY (`news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='news data';
2、插入日期到数据库
//先设置时区
ini_set('date.timezone','Asia/Shanghai');
//获取时间
$news_time = date("Y-m-d H:i:s",time());
$sql = "INSERT INTO news (news_title, news_text, news_time, user_id) VALUES (:news_title, :news_text, :news_time, :user_id)";
3、从数据库取出并自定义时间格式,$value->news_time为从数据库取出的值,显示格式为 2014/09/01
echo date("Y/m/d",strtotime($value->news_time));