我有以下代码:
$query = $this->EE->db->select('*')->where('form_name', 'Newsletter')->get('freeform_entries');
$filename = "newsletter.csv";
$path = "some/path";
$delimiter = ",";
$newline = "rn";
$csv_data = $this->EE->dbutil->csv_from_result($query, $delimiter, $newline);
但是其中一个字段是时间戳,我需要将其转换为日期时间,以便在输出为 csv 时就是它的样子。 所以我需要 20-10-13 09:28 而不是1357752502
有什么想法吗?
FROM_UNIXTIME将unix_timestamp参数的表示形式作为"YYYY-MM-DD HH:MM:SS"中的值返回:
$query = $this->EE->db->select('FROM_UNIXTIME(timestamp_field) AS "value"', ... )->where('form_name', 'Newsletter')->get('freeform_entries');
$filename = "newsletter.csv";
$path = "some/path";
$delimiter = ",";
$newline = "rn";
$csv_data = $this->EE->dbutil->csv_from_result($query, $delimiter, $newline);
更多信息:http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_from-unixtime