mysql - 仅使用TIMESTAMP SQL中的日期

我使用select命令获得“created_at”。这是创建行的日期。指挥结果为2018-07-29 15:29:57。如何只显示日期和删除时间。
当前结果：2018-07-29 15:29:57
期望结果：2018-07-29

SELECT treatment_log.created_at
FROM treatment_log
LEFT JOIN customers
    ON treatment_log.treatment_fk = customers.id
WHERE treatment_log.created_at =
        (
            SELECT MAX(created_at)
            FROM treatment_log
            WHERE treatment_fk = ?
        )
    AND customers.id = ?

如何更改当前代码？

最佳答案

嗨下面是解决方案
Sql服务器：

SELECT CAST(treatment_log.created_at as DATE)
FROM treatment_log
LEFT JOIN customers
    ON treatment_log.treatment_fk = customers.id
WHERE treatment_log.created_at =
        (
            SELECT MAX(created_at)
            FROM treatment_log
            WHERE treatment_fk = ?
        )
    AND customers.id = ?

对于我的SQL

SELECT DATE(treatment_log.created_at)
FROM treatment_log
LEFT JOIN customers
    ON treatment_log.treatment_fk = customers.id
WHERE treatment_log.created_at =
        (
            SELECT MAX(created_at)
            FROM treatment_log
            WHERE treatment_fk = ?
        )
    AND customers.id = ?

关于mysql - 仅使用TIMESTAMP SQL中的日期，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/51605829/

Customers

mysql - 仅使用TIMESTAMP SQL中的日期