MySQL DATE_FORMAT with Active Record

MySQL DATE_FORMAT with Active Record

03-14-2008, 03:10 PM

[eluser]mironcho[/eluser]
Hi,
You can try this:

Code:
$this->db->select("DATE_FORMAT(your_date_field, 'Year: %Y Month: %m Day: %d') AS formated_date");

$query = $this->db->get('your_table');

Messages In This Thread

MySQL DATE_FORMAT with Active Record - by El Forum - 03-14-2008, 03:00 PM

MySQL DATE_FORMAT with Active Record - by El Forum - 03-14-2008, 03:10 PM

MySQL DATE_FORMAT with Active Record - by El Forum - 03-14-2008, 03:11 PM

MySQL DATE_FORMAT with Active Record - by El Forum - 02-20-2009, 07:09 AM