MySQL TIMESTAMPDIFF 函数不返回预期结果

Question

SELECT
  M.strMemID                                          AS 'Member ID',
  M.strMemLastname                                    AS 'Last Name',
  M.STRMEMFIRSTNAME                                   AS 'First Name',
  M.strMemMiddlename                                  AS 'Middle Name',
  TIMESTAMPDIFF(YEAR, m.dtmMemBirthday, CURRENT_DATE) AS 'Age'
FROM TBLMEMBER M
WHERE m.strMemID NOT IN (SELECT DISTINCT m.strmemid
                         FROM tblmember m, tblmemberministry mm, tblpositionmemberministry pmm
                         WHERE m.strMemID = mm.strMMMemID AND mm.strmemmincode = pmm.strpmmmemmincode AND (
                           pmm.strPMMCode = 'POS041' OR PMM.STRPMMCODE = 'POS009' OR PMM.STRPMMCODE = 'POS010' OR
                           PMM.STRPMMCODE = 'POS012' OR PMM.STRPMMCODE = 'POS017' OR PMM.STRPMMCODE = 'POS021' OR
                           PMM.STRPMMCODE = 'POS028' OR PMM.STRPMMCODE = 'POS031' OR PMM.STRPMMCODE = 'POS037' OR
                           PMM.STRPMMCODE = 'POS039') AND mm.dtmMMDateQuit IS NULL AND pmm.dtmpmmdateto IS NULL AND
                               TIMESTAMPDIFF(YEAR, m.dtmMemBirthday, CURRENT_DATE) > 30);

这是我的代码。请忽略令人困惑的子查询。我的目标是显示 age > 30 的成员。我正在使用 TIMESTAMPDIFF。但是此查询返回的结果与年龄在 30 岁以下的人一样。有人可以帮助我吗？

Answer 1

我的坏人。我没有看到我的 TIMESTAMPDIFF(YEAR, m.dtmMemBirthday, CURRENT_DATE) > 30 在我的子查询中。现在解决了伙计们!无论如何谢谢。