Convert strftime to SQLite query for MySQL

Question

I converted the SQLite string

WHERE strftime('%d%m', orders.created_at) = .......

directly to the MySQL monster:

WHERE CONCAT(CAST(DAY(orders.created_at) AS CHAR), LPAD(CAST(MONTH(orders.created_at) AS CHAR), 2, '0')) = .........

Please help me rewrite it to a shorter one.

Answer 1

STRFTIME () in SQLite is similar to DATE_FORMAT () in MySQL with modified parameters.

Since %dand %mare compared with the same in both, your expression could simply be written as:

WHERE DATE_FORMAT(orders.created_at, '%d%m') = .......