mysql - 在 MySQL 中根据月份检索日期

Question

我正在尝试根据创建记录的月份选择年份值:

如果月份是一月以后，我应该得到去年如果月份是四月起，我应该是今年的

SELECT IF ((MONTH(Application.created) > 3), (YEAR(Application.created)), (YEAR(Application.created, INTERVAL -1 YEAR))) FROM Table

Answer 1

您可以从年份值中减去 1(不需要 interval)。另外，我使用了 CASE 因为我迷失在所有括号中:)

SELECT
  CASE WHEN MONTH(Application.created) > 3 THEN YEAR(Application.created)
       ELSE YEAR(Application.created) - 1
  END
FROM Table

编辑:

SELECT IF ((MONTH(Application.created) > 3), (YEAR(Application.created)), (YEAR(Application.created) - 1)) FROM Table