mysql - SQL select true if 日期比较

Question

如果日期小于特定时间，是否可以返回 bool 值作为选择字段？

例如，类似:

SELECT true IF (mydate < NOW())

或者类似的东西？

Answer 1

SELECT
    CAST(CASE WHEN mydate< getdate() THEN 1 ELSE 0 END AS bit) AS mydate
FROM
    MyTable WHERE (ID = 1)


-- Another approach might be 

SELECT
    CAST(COUNT(*) AS bit) AS mydate
FROM
    MyTable
WHERE
    ID = 1 AND mydate < getdate()