Closed
Description
Sorry my english :)
$result = $DB->rawQuery('SELECT DATE_FORMAT(start_date
, "%Y") start_date FROM city_events WHERE start_date
< ?', array('2013-04-01'));
it is not work!
$result = $DB->rawQuery('SELECT DATE_FORMAT(start_date
, ?) start_date From city_events WHERE start_date
< ?', array('%Y', '2013-04-01'));
$result is empty
if the where condition is "start_date
> ?" (reverse relation)
it is work
$result = $DB->rawQuery('SELECT start_date
From city_events WHERE start_date
< ?', array('2013-04-01'));
it is work, but date is not formated
Metadata
Metadata
Assignees
Labels
No labels