如何从SQLite中的日期时间结果列中检索日期部分？

我有一个datetime类型的列，我想从中检索只有日期。是否还有这样做？

I have a column of datetime type from which I would like to retrieve only the date. Is there anyway to do this?

以前是一个时代值，我将它转换为datetime。

Previously it was an epoch value where I convert it to datetime .

这是一个示例结果：

smbd|ip address|1082|ip address|"2011-04-26 18:40:34"

我尝试了以下命令，但它产生负/零结果

I have tried the following commands, but it yields negative / zero results

SELECT DATE(datetime) from attacked_total;
SELECT STRFTIME('%Y-%m-%d', datetime) FROM attacked_total;
SELECT DATETIME('%Y-%m-%d', datetime) FROM attacked_total;
SELECT DATE('%Y-%m-%d', datetime) FROM attacked_total;