mysql 时间差问题集锦

SELECT * from grouptoadd where taskid = '103244';

select datediff(max(spreadtime),min(createtime)) from grouptoadd where taskid = '103244';

-- 【mysql】时间差
SELECT TIMESTAMPDIFF(DAY, createtime ,spreadtime) AS `DAY` from grouptoadd where taskid = '103244';

SELECT TIMESTAMPDIFF(HOUR, createtime ,spreadtime) AS `HOUR` from grouptoadd where taskid = '103244';

SELECT TIMESTAMPDIFF(MINUTE, createtime ,spreadtime) AS `MINUTE` from grouptoadd where taskid = '103244';

SELECT TIMESTAMPDIFF(SECOND, createtime ,spreadtime) AS `Second` from grouptoadd where taskid = '103244';

如果一件事情你觉得难的完不成，你可以把它分为若干步,并不断寻找合适的方法。最后你发现你会是个超人。不要给自己找麻烦，但遇到麻烦绝不怕，更不要退缩。电工查找电路不通点的最快方法是：分段诊断排除，快速定位。你有什么启示吗？求知若饥，虚心若愚。当你对一个事情掌控不足的时候，你需要做的就是“梳理”，并制定相应的规章制度，并使资源各司其职。