将SQLite请求中的strftime转换为MySQL [英] Convert strftime in SQLite request to MySQL

问题描述

我转换了SQLite行

I converted the SQLite line

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

直接针对MySQL怪物:

directly to a MySQL monster:

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

请帮助我将其重写为较短的内容.

Please, help me to rewrite it to a shorter one.

推荐答案

STRFTIME()与<在MySQL中具有反向参数的href ="http://dev.mysql.com/doc/refman/5.5/zh-CN/date-and-time-functions.html#function_date-format"> DATE_FORMAT().

由于%d和%m都映射到相同的事物，因此您的表达式可以简单地写为；

Since %d and %m map to the same thing in both, your expression can simply be written as;

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

这篇关于将SQLite请求中的strftime转换为MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！