99. 構文 @DATEDIFF (' difference ', ' date ', ' date ') difference. Oracle equivalent to SQL Server/Sybase. sql. Apart from using Joda time which seems to be the the favorite suggestion I'd offer the following snippet: public static final int getMonthsDifference (Date date1, Date date2) { int m1 = date1. I have a request to build a set of worksheets that accept an intial parameter - Start Date in the format MMM YYYY. 21. Asked 7 years, 2 months ago. Get the difference between datetimes in years, months, and days down to seconds. Hi tom, I want day, month, minute and years difference everyting in seconds. The function will always return the difference between two dates in days. Modified 8 years, 2 months ago. Tarek Fathy Nov 18 2010 — edited Nov 18 2010. BaseDate. The difference between two dates (in oracle's usual database product) is in days (which can have fractional parts). This can have results that you are not expecting. Using SQL Server, I would do something like: select dateadd (month, num, firstdate) as mon from (select row_number () over (partition by NULL order by (select NULL)) as num from Information_Schema. UPDATE Yes, he will get a 1 month difference even if it is only 1 day difference, but OP. Syntax The syntax for the MONTHS_BETWEEN function in Oracle/PLSQL is: MONTHS_BETWEEN ( date1, date2 ) Parameters or Arguments date1 The first date used to calculate the number of months between. NET and i have faced several problems that i could fix but i couldn't fix the following: I have a stored procedure that takes date in parameters The stored procedures calls to_date with the format : MM/DD/YY HH:MI:SS AM The. MONTHS_BETWEEN gives the number of whole months between the 2 dates, and calculates the fractional part as the remainder in days divided by 31. NEW_TIME (date, timezone1, timezone2) Timestamp. I have an application which calculates age on the specific date completely that is in years-months-days . Share. This function is not sensitive to the NLS_CALENDAR session parameter. Date. You can even find the number of hours, minutes, seconds, and so on in terms of details in. 6. Examples of Results in Months. DATE_ADD () Add time values (intervals) to a date value. Learn how to use The SQL Server DATEDIFF() Function to return the difference between two dates. date_from, evnt. I believe you want: Select id, datediff (day, min (hire) max (hire)) as Difference From Employees group by id having count (terminated) < count (*) -- at least one NULL value. If either expression is a character or graphic string, it must not be a CLOB. In this article, I would like to show the difference between two dates in years, months and days in SQL Server. (Oct 2006 - June 2005 = 16) DP_WEEK returns the distance between the weeks capturing the input dates. EXECUTION_DATE, EXEC_DIFF 01-FEB-13, 1 31-JAN-13, 2 30-JAN-13, 2. SELECT DATEDIFF (YY, DateOfBirth, GETDATE ()) - CASE WHEN RIGHT (CONVERT (VARCHAR (6), GETDATE (), 12), 4) >= RIGHT (CONVERT (VARCHAR (6), DateOfBirth, 12), 4) THEN 0 ELSE 1 END AS AGE. But since it's a finite set, you can just get. for example Feb-15th to Mar-15th is a month. We need to pad a zero for single-digit months. 3. The number is the number of seconds elapsed since midnight, January 1, 1970. Delaying Execution. Here’s the syntax for the DATEADD function: DATEADD (interval, number, date); The interval. g. Syntax: TIMESTAMPADD (interval, expr, timestamp) Example: TIMESTAMPADD (SQL_TSI_MONTH, 12,Time. Consider SQL Server function to calculate the difference between 2 dates in months: SQL Server : -- Difference between Oct 02, 2011 and Jan 01, 2012 in months SELECT DATEDIFF ( month, '2011-10-02', '2012-01-01') ; -- Result: 3. I am adding filter to OTBI report and want system to take first and last date of current month automatically. As another option you could use the months_between () function, and manipulate the value that gives you into the three. (The valid formats 1,7,10,11 will be described later. . – user330315. This gets the year difference between the birth date and the current date. Improve this question. Sep 16, 2015 at 5:55. DATEDIFF Examples Using All Options. 一重引用符で囲んだ'YYYY-MM-DD[*HH:MI[:SS]]'形式の文字列(*はコロン(:)または空白でも可)、または現在の日付を返す引用符なしの@DATENOW. hourEnd)) AS Expr1 FROM a INNER JOIN tp ON a. Date 1: 10th March 2011. 510345 May 24 2006 — edited May 24 2006. From the Oracle documentation: MONTHS_BETWEEN returns number of months between dates date1 and date2. g. Instead, use the dateAdd function on todays date, and compare the database table column to the result of that single calculation. DATEDIFF (datepart, startdate, enddate) which can return the difference in years, months, days etc. SELECT DATEADD(WEEK, DATEDIFF(WEEK,0,GETDATE()),-3) Executes. 14977 Days 7 Hours 36 Minutes 56 Seconds. In SQL, we can add or subtract days, months, or years to a date by using the DATEADD function. この数値は、1970年1月1日の深夜から経過した秒数です。. See Date and Time Data Types and Functions (Transact-SQL) for an overview of all Transact. 4 Answers. 000000. ReturnDate)) + ' days') ELSE CAST(DATEDIFF(day, Trips. for example Feb-15th to Mar-15th is a month. datediff() is not giving tHe result as I am working in Oracle. =DATEDIFF ("d", Fields!startDate. The basic approach to show all duration units for a period is: Find the complete. Hi Ive been having an issue with getting the correct difference in a date from the current month not including the day. To get the number of month or day, you change the first argument to month or day as shown below: Notice that the DATEDIFF () function takes the leap year into account. 2188940092 Example 2 Date 1: 10th March 2011 Date 2: 1st Feb 2011 MONTHS_BETWEEN = 1. So subtracting a TIMESTAMP WITH TIME ZONE that is 5 am Eastern from a TIMESTAMP WITH TIME ZONE that is 2 am Pacific will result in an interval of 0. getYear () * 12 + date2. 9. Then it subtracts a year if the birthdate hasn't passed. In SQL Server 2012 and above, you can use the EOMONTH function to return the last day of the month. The week (wk, ww) datepart reflects changes made to SET DATEFIRST. I am looking for solution how to select number of days between two dates without weekends and public holidays. Its answer is 2014-08-17. (CASE WHEN Trips. maybe something like passing an "m" as one of the parameters. 33 shows the available functions for date/time value processing, with details appearing in the following subsections. . Expressions that return a value of any of the following built-in data types: a date, a timestamp, a character string, or a graphic string. 9. (Oct 2006 - June 2005 = 16) DP_WEEK returns the distance between the weeks capturing the input. 3. Here, since you need to subtract one day, you use current_date – 1 . 29 Answers. 2 Answers. @KanagaveluSugumar - An Oracle DATE always has a year, month, day, hour, minute, and second component. Modified 1 year, 3 months ago. Also, you need to put your dates into single quotes: use '2-2-2011' instead of simply 2-2-2011. The first quarter is 1, the last one is 4. The days are in two different, adjacent months, so the answer is 1 month difference. Simply i need to convert this: SELECT FLOOR(DATEDIFF(NOW(),`startdate`)/365. 取得一季中的第一天：. January 30, 2004 - 7:26 pm UTC. SQL is also known as Structured Query Language. SQL Database Dates is a MUST for. "Order Date") Description: Adds a specified number of intervals to a timestamp, and returns a single. First you get the number of years from the birth date up to now. You can substitute the parameters used as an example for the values in your query. The Oracle/PLSQL MONTHS_BETWEEN function returns the number of months between date1 and date2. Getting the months and years between two dates using Datediff There is a round up issue with the Datediff function. 365 days elapse between the two dates. If you enter a negative parameter, the system subtracts the specified days, months, or years. TASKUNIQUEID, PROJ_TASK. Improve this answer. COMPUTE days3 = CTIME. Ecco una semplice funzione per calcolare la differenza tra due date. Improve this answer. SQL Server ignores that this is just one day. It means that the DATEPART function returns the number of times the boundary between two units is crossed. The idea is to find how many years, months, and days they have served there. SYSDATE) and subtracting a date from a timestamp (e. See the following conditions: If date1 is later than date2,. The following illustrates the syntax of the DATEPART. Click on the function name to jump to a discussion of that function. count the number of elapsed time, taking care of daylight savings: day+1 - day = 1 = 24h (but using midnight time and daylight savings it could be 0 day and 23h)Find Difference Between two dates in YEARS with Oracle. ;-). AVERAGES CTE shows how to apply AVG function to. SQL> ed Wrote file afiedt. I have the following query that I'm trying to get the length of service of a person at their company. Oracle offers its own solution, although does not have the DATEDIFF function. (The valid formats 1,7,10,11 will be described later. I had a problem with a date query using the operator 'between'. The math is 100% accurate for dates within a couple of hundred years or so. Modified 9 years, 7 months ago. I was following along with the toad workbook 101 video (Toad Data Point Workbook 101: The Ins and Outs) and really wanting to replicate the presenter's use of the date diff() function. The first day of the year is 1. I tried going off of something like this: Select records from SQL Server if greater than 6 months but I get the error: Subquery returned more than 1 value. 3. Right-click and select Convert to Date. date. you can check against last 90 days. Viewed 32k times. SELECT TIMESTAMPDIFF (MONTH, '2012-05-05', '2012-06-04') -- Outputs. Each Standard calendar week is. We will be using the same employees table in order to demonstrate the intricacies of calculating the difference between two dates in terms of weeks, months, or years using MySQL’s DATEDIFF() function. Select Sysdate-Birth_date from Employees; the query return the number of days between the two dates. It means that the DATEPART function returns the number of times the boundary between two units is crossed. id = a. oracle difference between two dates in years Code Example. 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 case statement that decrements the result. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. In Oracle, MONTHS_BETWEEN(date1, date2) function returns the number of months between two dates as a decimal number. To get the months or years separately, use extract. Modified 5 years, 9 months ago. References: ( found on on 05/15/2015 ) 1. dp_monthは、入力日付を取得する月間の距離を返します。 (2006年10月) - 2005年6月= 16) dp_weekは、入力日付を取得する週間の距離を返します。 各標準カレンダ週は日曜日に始まり、7日にまたがるように定義されています。 (2006年10月10日 - 2005年6月14日= 69)The result only contains the year, month and day, not the time. This page provides you with the most commonly used Oracle date functions that help you handle date and time data easily and more effectively. numeric-expression. Click Add Step to convert your column to a DateTime field. Few examples of DATEDIFF: DATEDIFF - Example 1 Here, in this example, datepart is "day": SELECT DATEDIFF(day,'2016-06-05','2016-08-05') AS DiffDate Result: DiffDate 61 If the endDate has a day part less than startDate, it will get pushed to the previous month, thus datediff will give the correct number of months. 1. 65. e. So it's not an accumulative difference, it's only when a date is within a smaller month. TIMESTAMPDIFF ( numeric-expression string-expression. Currently, my code just returns zero on the right side of the decimal place. Modified 9 years ago. DATEDIFF can return negative numbers. - Find the “date_diff” in minutes and add it with the “date_diff” in hours and the “date_ diff” in days. To break the diff between 2 dates into days, hours, minutes, sec -- you can use the following: Dy gives you number of days between 2 dates (partial days discarded). I was given code via an SR but it doesn't work (I'm able to save the code but when I try to look at the sample data, it just says "error"). Can Any one help me please. CREATE OR REPLACE FUNCTION datediff (p_what IN VARCHAR2, p_d1 IN DATE, p_d2 IN DATE) RETURN NUMBER /* Updated to reflect current database and PL/SQL functionality */ AS BEGIN RETURN (p_d2 - p_d1) * CASE UPPER (p_what) WHEN 'SS' THEN 24 * 60 * 60 WHEN 'MI' THEN 24 * 60 WHEN 'HH' THEN 24 ELSE NULL END; END;SELECT months_between ( date_1, date_2 )/12 years_between FROM employee. 997268 (0 year + 365/366 years) So, in summary, the output (in DECIMAL (7,6)) from the above two examples would be: 1. What I am using is (Today-Dob)/30/12, but this is not accurate as some months have 31 days. Difference of two dates in months. DP_MONTH returns the distance between the months capturing the input dates. 2188940092. In this article, we take an existing date and the current date and using the "GetDate" function to find the years, months and days. To calculate the number of days between date1 and date2, you can use either Day of. The Question asked for "6 months from the system date". However, The. WEEK: returns the week number in the year. ) and the. How to generate days, weeks, or months between two dates in Oracle Database June 1, 2021 | 25 minute read Chris Saxon Developer Advocate There are. Also, to get the end date for the quarter, just use: select dateadd (quarter, datediff (quarter, 0, SomeDate)+1,0) -1. AT TIME ZONE. February 28 and March 28) and when the days of the month are the last day of the month (e. E. --Changing current database to the Master database allows function to be shared by everyone. id = al. The second parameter defaults to the current date. i need to find the difference of two dates as the number of months: find the last day of the month of both the dates. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. AT TIME ZONE. user637544 Jun 1 2009 — edited Jun 1 2009. current_timestamp() returns the timestamp on the database client side. Here's an example. get the previous last date of the month in oracle sql. Note that it is subtracting the second from the first, so you must have them in this order. 032258 在本文中，我们介绍了oracle数据库中的datediff函数。通过指定日期部分、开始日期和结束日期，我们可以使用datediff函数计算两个日期之间的差异。这对于计算日期之间的天数、小时数、分钟数等非常有用。希望本文对您理解datediff函数的使用有所帮助。 the problem lies in the fact that a month is a nebulous thing - it is not a precise number of days. Oracle's database does not have (nor need) a datediff() function. The table contains the data about each staff member’s employment date. DOW: returns the day of the week, between Sunday (0) and Saturday (6) DOY: returns the day of the year. Notice that the first row has a difference of 1. In SQL Server 2012 you can use EOMONTH (Transact-SQL) to get the last day of the month and then you can use DAY (Transact-SQL) to get the number of days in the month. Example. 指定した日付の差異。次の値が有効です。 DD: 差異を日数で計算します。. , YEAR, MONTH, DAY,. CASE WHEN a. Assuming that a. The dates do not have to be in the same format in the extract file, but the format of each must be supported. EXE. For example, you might use DateDiff to calculate the number of days between two dates, or the number of weeks between today and the end of the year. CREATED = TO_DATE. SELECT months_between ( date_1, date_2 )/12 years_between FROM employee. PostgreSQL. If you want to format it as you wanted (note that mm format mask is for months; mi is for minutes), then you could do some extracting - again from timestamp (won't work for date):. DATEDIFF accepts either. trunc ( months_between ( end_date, start_date ) /12 ) Years, mod ( trunc ( months_between ( end_date, start_date ) ), 12 ) months, end_date - add_months (start_date,trunc ( months_between (end_date,start_date) )) days. But when I searched for it, it wasn't available. Goal. 2. The system calculates the number of complete months between given dates. 2. FLOOR (DATEDIFF (DAY, date_of_birth, reference_date) / 365. date1. ----- we travel not to escape life but for life not to escape us. Order your results by the number of years employed. You have to cast it first, using to_date: select to_date ('2000-01-01', 'yyyy-MM-dd') - to_date ('2000-01-02', 'yyyy-MM-dd') datediff from dual ; The result is in days, to the difference of these two dates is -1 (you could swap the two dates if you like). select trunc (months_between (:end_date,. 2. PROJECTID, PROJ_TASK. 1 Answer. ops$tkyte@8i> select months_between ( end_date, start_date ), 2 trunc ( months_between ( end_date, start_date ) /12 ) Years, 3 mod (. Parameter Description; date1, date2: Required. * 12 + (Extract(Month From CDate(EndDate)) - Extract(Month. @Bruno - If the data types are TIMESTAMP WITH TIME ZONE, the interval that results from subtracting the two should take care of any time zone/ daylight savings time conversion. Then it would also be helpful to be able to. For many values of the local settings, this would simply fail. 1. @WernfriedDomscheit YYYY-MM-DD is not a date it is just a formatted string. Admission_Date) > 5. Valid values can be: DD, which computes the difference in days. Follow. select trunc ( (sysdate - to_date ('2012-02-28 15:20', 'YYYY-MM-DD hh24:mi')) / 24) from dual; You should have multiplied by. For example, using the standard SCOTT. There are two methods to achieve this. FromDate, r. edited May 15, 2013 at 7:42. Factor by 24 to get hours, 24*60 to get minutes, 24*60*60 to get seconds (that's as small as dates go). SQL DATEPART. For example, suppose you have values below the start and end times. 2425. select S. I don't think this is really important to your question. The system calculates the number of complete months between given dates. However, since you have known start- and end-dates then you can find the number of full years between the two bounds and then use an INTERVAL DAY TO. 25) This seems to be another common approach - and was also given in a comment on my question. Also to note that: DATEDIFF. ORA-00937 when calculating a sub-value in an aggregate select statement. The format argument is optional. · User1416329745 posted ANSI SQL 1992. For example: print &order_date () edit 'Month dd, YYYY'. In PostgreSQL there are basically 2 functions to do the same, as we have both date_part and extract: SELECT current_date AS ACTUAL_DATE, EXTRACT (DAY FROM current_date) AS ACTUAL_DAY, EXTRACT (MONTH FROM current_date) AS ACTUAL_MONTH, EXTRACT (YEAR FROM current_date) AS ACTUAL_YEAR. Tarek Fathy Nov 18 2010 — edited Nov 18 2010. Conversion between time units is also allowed; you can add, subtract, or compare dates by using days and state. . I wanted to make the year as text in date dimension. 4193548. select level rn from dual connect by level <= 3; RN 1 2 3. SELECT floor ( months_between ( date_1, date_2 )/12) floor_years_between FROM employee. The following table lists all the valid datepart values. show moreHere is an example that uses date functions. The syntax for the DATEDIFF function in SQL Server (Transact-SQL) is: DATEDIFF( interval, date1, date2 ) Parameters or Arguments interval. Factor by 24 to get hours, 24*60 to get minutes, 24*60*60 to get seconds (that's as small as dates go). Getting the last 12 months from a specific date is easy and can be retrieved by the following command in SQL-server. . 一重引用符で囲んだ'YYYY-MM-DD[*HH:MI[:SS]]'形式の文字列(*はコロン(:)または空白でも可)、または現在の日付を返す引用符なしの@DATENOW. Try SELECT SYSTIMESTAMP + INTERVAL '5' MINUTE, SYSTIMESTAMP + 5 / 24 / 60 to convince yourself. 5. getYear () * 12 + date1. This will return an interval that may look something like “1 year 2 months 3 days”. Select Sysdate-Birth_date from Employees; the query return the number of days between the two dates. Compare dates problems. Once you have the date difference, you can use simple. Then, we need a 2-digit month string. I don't think that you need to write your own timestampdiff function since oracle already has one: EXTRACT. DATEDIFF (MONTH, DATEADD (DAY,-DAY (startDate)+1,startDate),DATEADD (DAY,-DAY (startDate)+1,endDate)) Share. I want to calculate the current Age from Date of Birth in my Oracle function. Also, according to Oracle's documentation LAST_DAY returns a DATE. Date2Date. subtract and give the difference in number of months. SELECT DATEADD ( quarter, DATEDIFF. Note that SQL Server DATEDIFF(month, date2, date1) function does not return exactly the same result, and you have to use an user-defined function if you need to fully emulate the Oracle MONTHS_BETWEEN function (see. How to unite two columns of date + time for datediff - Oracle sql. user637544 Jun 1 2009 — edited Jun 1 2009. Now for testing purposes I need to compare the data for the last say 4 months from the sysdate. Next to calculate a month of services in a company by a user we would use ‘m’ to calculate the difference value. 0. In a table called ‘Employees’ with columns ‘EmployeeID’, ‘Name’, and ‘HireDate’, we can calculate the number of months since each. SQL Server DATEDIFF ( DATEPART , STARTDATE , ENDDATE ) Example: Select Datediff(mm,column1,column2) Above script will output difference in months, so based. There is no datediff in Oracle. by: sandy | last post by: Hi, Using Java script I am trying to create code where when you place in the start date it automatically calculates 6 months for the experations date. What this allows you to do is pass in two TIMESTAMP or DATETIME values (or even DATE as MySQL will auto-convert) as well as the unit of time you want to base your difference on. DECLARE @ADate DATETIME SET @ADate = GETDATE () SELECT DAY (EOMONTH (@ADate)) AS DaysInMonth. If you subtract from one date other you will get a count of days between this two dates. Sorted by: 10. 032258the problem lies in the fact that a month is a nebulous thing - it is not a precise number of days. Note that SQL Server DATEDIFF(month, date2, date1) function does not return exactly the same result, and you have to use an user-defined function if you need to fully emulate the Oracle MONTHS_BETWEEN function (see UDF's code below). e it takes the quarter in which the start date exists and subtracts it from the quarter in which the end date exists. Here’s the step by step: Use the AGE function to calculate the difference between the end date and start date. dividing by 365. buf 1 declare 2 total_days integer; 3 total_weeks integer; 4 remaining_days integer; 5 begin 6 total_days := date '2014-12-16' - date '2014-12-01'; 7 total. For formatting functions, refer to Section 9. To get the number of months you could use months_between. The default is date format 1. Difference of two dates in months user637544 Jun 1 2009 — edited Jun 1 2009 i need to find the difference of two dates as the number of months: find the last day. The function supports units of years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds, microseconds, and nanoseconds. EMP table and assuming every month has 30 days: SQL> SELECT SYSDATE, 2 hiredate, 3 TRUNC (months_between. For DATEDIFF: date_or_time_expr1 and date_or_time_expr2 can be a date, time, or timestamp. 5 days to a given date. Datediff (cast ('2020-08-01' as Date),Cast ('2020-07-31' as Date)) => 1. As you can see the EOMONTH function takes into account leap year. . 1. DATEADD ('week', 1, [due date]) Add 280 days to the date February 20, 2021. That's certainly the standard way to do that sort of date arithmetic in Oracle. If date1 is earlier than date2, then the result is negative. To find the date difference in minutes from the given DateTime values, use the following steps: - First, find the “date_diff” in days and multiply it with “24”. It supports a large number of languages and application development frameworks. Dates are always a joy to work with in any programming language, SQL not excluded. (year/month/date from date) //oracle function for extracting values from date. FWIW, you don't need to use floor. Oracle's MONTHS_BETWEEN on the other hand tries to calculate an exact difference in months' fractions: select months_between(date '2021-02-01', date '2021-01-31') from dual; => 0. I have to get the date from the system and calculate the date difference in days. You can use this methodology to determine the first day of 3 months ago, and the last day of the previous month: select DATEADD (MONTH, DATEDIFF (MONTH, 0, GETDATE ())-3, 0) --First day of 3 months ago select DATEADD (MONTH, DATEDIFF (MONTH, -1, GETDATE ())-1, -1) --Last Day of previous month. In this Document. 1. SS: 差異を秒数で計算します。. Again, under Column Tools you have the option for Sort by column. Select DATEDIFF (MM,0,GETDATE ()) Output - 1374, If getdate () output is "2014-07-23 19:33:46. Oracle equivalent to SQL Server/Sybase DateDiff. Access Function: DateDiff ("m",PAID_DATE,STATIC_DATE) AS Months_Between. id INNER JOIN al ON ac. But your query is giving the last date of previous month. Delaying Execution. To get the months or years separately, use extract. You want to pass TIMESTAMP arguments to the function and when you add years you also need to ensure that you propagate the fractional component of the timestamp (since ADD_MONTHS returns a DATE data-type without fractional seconds):Unfortunately, Oracle SQL doesn't allow the DATEDIFF function. date_open END. Conversion among time units is also allowed; you can add, subtract, or compare dates by using days and state. Viewed 20k times. Kindly help on this. SELECT startDate, endDate, DATEDIFF( endDate, startDate ) AS diff_days, CAST( months_between( endDate, startDate ) AS INT ) AS diff_months FROM yourTable ORDER BY 1; There are also year and quarter functions for determining the year and quarter of a date respectively. I hope you will like the SQL Date Functions Examples article. Again, the expected results would be a value of 1. 25 = 0. 1. One way to get our “DateDiff” function to exclude holidays and weekends is to have a calendar table pre-populated with some or all the information you need, and then use that table to exclude the dates. Also, you can check this for minutes : Oracle : how to subtract two dates and get minutes of the result. dividing by 365. Viewed 2k times 1 I need to calculate the number of days between two dates as decimal, excluding the weekends and holidays by using a custom function in Oracle SQL. select *, cast ( (cast (begin_date as date) - cast (end_date as date) YEAR) as decimal (3,2)) AS year_diff from x. Currently I am only returning 1. 2258064516. SELECT EOMONTH ('02/04/2016') Returns 02/29/2016. You can simply subtract two dates. You'll get a more accurate result if you compute the difference between the two dates in days and divide by the mean length of a calendar year in days over a 400 year span (365. should work fine. Parameter Description; interval: Required. . 2323 days) multiply by 24 = hours, another 60 = minutes, another 60 = seconds.