When you need something like that on server side, you usually create a table which contains all possible dates between two points in time, and then left join this table with query results. Something like this: create procedure sp1(d1 date, d2 date) declare d datetime; create temporary table foo (d date not null); set d … Read more
Since PHP 5.3 There is another option without to write an extension. This example show how to calc the plural day/days {# endDate and startDate are strings or DateTime objects #} {% set difference = date(endDate).diff(date(startDate)) %} {% set leftDays = difference.days %} {% if leftDays == 1 %} 1 day {% else %} {{ … Read more
how about trying this, not sure why you have stime = [exceptions2].starttime and etime = [exceptions2].endtime SELECT datediff(minute, starttime, endtime) from Exceptions2
How precise do you need to be? If you do need to take into account common years and leap years, and the exact difference in days between months then you’ll have to write something more advanced but for a basic and rough calculation this should do the trick: today = new Date() past = new … Read more
You could use python-dateutil. In [4]: from datetime import datetime In [5]: date1 = datetime.strptime(str(‘2011-08-15 12:00:00’), ‘%Y-%m-%d %H:%M:%S’) In [6]: date2 = datetime.strptime(str(‘2012-02-15’), ‘%Y-%m-%d’) In [7]: from dateutil import relativedelta In [8]: r = relativedelta.relativedelta(date1, date2) In [9]: r Out[9]: relativedelta(months=-5, days=-30, hours=-12)
You can convert the duration to a date and then format it: DECLARE @FirstDate datetime, @LastDate datetime SELECT @FirstDate=”2000-01-01 09:00:00″, @LastDate=”2000-01-01 11:30:00″ SELECT CONVERT(varchar(12), DATEADD(minute, DATEDIFF(minute, @FirstDate, @LastDate), 0), 114) /* Results: 02:30:00:000 */ For less precision, modify the size of the varchar: SELECT CONVERT(varchar(5), DATEADD(minute, DATEDIFF(minute, @FirstDate, @LastDate), 0), 114) /* Results: 02:30 */
The following seemed to work well for me: =DATEDIF(B2, Today(), “D”)
What about using TIMESTAMPDIFF? SELECT TIMESTAMPDIFF(HOUR, start_time, end_time) as `difference` FROM timeattendance WHERE timeattendance_id = ‘1484’
In Oracle, you can simply subtract two dates and get the difference in days. Also note that unlike SQL Server or MySQL, in Oracle you cannot perform a select statement without a from clause. One way around this is to use the builtin dummy table, dual: SELECT TO_DATE(‘2000-01-02’, ‘YYYY-MM-DD’) – TO_DATE(‘2000-01-01’, ‘YYYY-MM-DD’) AS DateDiff FROM … Read more
Here is some T-SQL that gives you the number of years, months, and days since the day specified in @date. It takes into account the fact that DATEDIFF() computes the difference without considering what month or day it is (so the month diff between 8/31 and 9/1 is 1 month) and handles that with a … Read more