SELECT with date_format

[baycoretech]

how to select column with custom date format? e.g : "SELECT * FROM table WHERE DATE_FORMAT(column,'%Y-%m-%d')='$date'" i tried $query_select->cols(['cr_visitorID', 'DATE_FORMAT(cr_visitorDate, %Y-%m-%d) as visitordate']) ->from('cr_visitor') ->where('visitordate = :date') ->bindValues([ ':date' => $mindate ]); not working, is there a function to select column with custom date format? or i have to use raw query? thank you :)

[pmjones]

not working

Can you say what the resulting query string actually looks like? E.g., by calling $select->getStatement().

[baycoretech]

I'm sorry for long reply and bad english :) I solved it, i have changed 'DATE_FORMAT(cr_visitorDate, %Y-%m-%d) as visitordate' to 'DATE_FORMAT(cr_visitorDate, \'%Y-%m-%d\') as visitordate'. Thanks :)