使用mySql获取剩余的天数，小时数和分钟数 [英] Get remaining days, hours and minutes using mySql

问题描述

我被困在mySql中获取两个日期之间的剩余天数，小时数和分钟数.

I am stuck in getting the remaining days, hours and minutes between two dates in mySql.

我有一个到期日期，我想将其与当前的DateTime进行比较，并希望获得天，小时和分钟.

I have an expiry date and I want to compare it with current DateTime and want to get days, hours and minutes.

推荐答案

此stackoverflow链接可能会帮助您.有两种方法可以计算两个日期之间的差异，并且您没有义务在完整的SQL中执行此操作.

This stackoverflow link may help you. There is many way to calculate difference between two dates and your are not oblige to do this in full SQL.

我已经找到了SQL解决方案...

I ve found a solution in SQL...

SELECT  TIMESTAMPDIFF(DAY,NOW(),'2012-01-01') AS DAY,
        TIMESTAMPDIFF(HOUR,NOW(),'2012-01-01')-TIMESTAMPDIFF(DAY,NOW(),'2012-01-01')*24 AS HOUR,
        TIMESTAMPDIFF(MINUTE,NOW(),'2012-01-01')-TIMESTAMPDIFF(HOUR,NOW(),'2012-01-01')*60 AS MINUTE;

这篇关于使用mySql获取剩余的天数，小时数和分钟数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！