Codeigniter - 使用日期格式将表记录导出为CSV

Question

here I am exporting the table result in CSV format and I want to format the date column something like this 2017-08-31, 13:10:12

anyone help me to modify this mySql query

$query = "SELECT DATE_FORMAT(created_on,'%Y-%m-%d , %H:%i:%s') AS OrderDate,transaction.order_id,transaction.payment_method FROM transaction";

and here is my Export to CSV function

function ExportCSV()
{
    $this->load->dbutil();
    $this->load->helper('file');
    $this->load->helper('download');
    $delimiter = ",";
    $newline = "
";
    $filename = "lugmah_sales_report.csv";
    $query = "SELECT DATE_FORMAT(created_on,'%Y-%m-%d , %H:%i:%s') AS OrderDate,transaction.order_id,transaction.payment_method FROM transaction";
    $result = $this->db->query($query);
    $data = $this->dbutil->csv_from_result($result, $delimiter, $newline);
    force_download($filename, $data);
}

Answer 1

Arsee, Better you try with This query SELECT DATE_FORMAT(FROM_UNIXTIME(created_on), '%e %b %Y') AS OrderDate,