我的数据库mysql带有table'tblevel'带列'waktu',带有varchar数据类型。并且该列具有这样的值:
30-01-2014 12:19:09
该值将转换为时间戳,因为我必须这样做以用于图形查看,在这种情况下,我使用Google数据可视化,
简短的代码是:
$result = mysql_query("SELECT TIMESTAMPDIFF(MINUTE,FROM_UNIX_TIMESTAMP(STR_TO_DATE(waktu, '%H:%i:%s %b %d, %Y')), now()) as waktu1,level,press FROM tblevel WHERE TIMESTAMPDIFF(MINUTE,FROM_UNIXTIME(waktu) , now()) < 120 Order By waktu");
希望有人帮助纠正代码。谢谢
对fixduino。
尝试以下:
SELECT a.waktu, a.level, a.press
TIMESTAMPDIFF(MINUTE, STR_TO_DATE(a.waktu, '%d-%m-%Y %H:%i:%s'), NOW()) AS waktu1
FROM tblevel a
WHERE TIMESTAMPDIFF(MINUTE, STR_TO_DATE(a.waktu, '%d-%m-%Y %H:%i:%s'), NOW()) < 120
ORDER BY STR_TO_DATE(a.waktu, '%d-%m-%Y %H:%i:%s');
mysql的日期格式是ymd,尝试以下
SELECT a.waktu, a.level, a.press
TIMESTAMPDIFF(MINUTE, STR_TO_DATE(a.waktu, '%y-%M-%d %H:%i:%s'), NOW()) AS waktu1
FROM tblevel a
WHERE TIMESTAMPDIFF(MINUTE, STR_TO_DATE(a.waktu, '%y-%M-%d %H:%i:%s'), NOW()) < 120
ORDER BY STR_TO_DATE(a.waktu, '%y-%M-%d %H:%i:%s');