mysql - 从时间戳 SQL 中选择日期

Question

我的数据库中有以下行:

'1', '1', '1', 'Hello world', 'Hello', '2014-01-14 17:33:34'

现在我想选择这一行并只从这个时间戳中获取日期:

我尝试了以下方法:

SELECT title,   FROM_UNIXTIME(timestamp,'%Y %D %M') AS MYDATE FROM Team_Note TN WHERE id = 1

我也试过:

SELECT title,   DATE_FORMAT(FROM_UNIXTIME(`timestamp`), '%e %b %Y') AS MYDATE FROM Team_Note TN WHERE id = 1

但是这些只返回一个空结果(或者我得到了 Hello 部分但是 MYDATE 是空的)

Answer 1

你试过吗？

SELECT title, date(timestamp) AS MYDATE
FROM Team_Note TN
WHERE id = 1