More than 3 years have passed since last update.

codeigniter3 データベースからYYYY/MM/DD形式で日付を取得する

Last updated at 2020-03-04Posted at 2020-03-03

codeigniter3でcreate_dateとupdate_dateをYYYY/MM/DDの形式で取得する

qiita.rb

$this->db->select(
'*,
DATE_FORMAT(create_date,"%Y/%m/%d") AS create_date,
DATE_FORMAT(update_date,"%Y/%m/%d") AS update_date,'
);