select starttime , localtimestamp() as localtime from match where timestampdiff(hour , starttime , localtime )>0startime 比赛开始时间
localtimestamp() 本地的当前时间
match 比赛表
timestampdiff 求时间的差
这样行吗?
localtimestamp() 本地的当前时间
match 比赛表
timestampdiff 求时间的差
这样行吗?
check the manual that corresponds to your MySQL server version for the right syntax to use near 'localtime from match where datediff(hour , starttime , GETDATE())>0'
right syntax to use near 'localtime from match where datediff(hour , starttime , GETDATE())>0' at line 1
但是hibernate里边,from之前是不是不能写东西?
这样的话,应该怎么处理?