date-arithmetic - w3toppers.com

Calculate business days in Oracle SQL(no functions or procedure)

The solution, finally: SELECT OrderNumber, InstallDate, CompleteDate, (TRUNC(CompleteDate) – TRUNC(InstallDate) ) +1 – ((((TRUNC(CompleteDate,’D’))-(TRUNC(InstallDate,’D’)))/7)*2) – (CASE WHEN TO_CHAR(InstallDate,’DY’,’nls_date_language=english’)=’SUN’ THEN 1 ELSE 0 END) – (CASE WHEN TO_CHAR(CompleteDate,’DY’,’nls_date_language=english’)=’SAT’ THEN 1 ELSE 0 END) as BusinessDays FROM Orders ORDER BY OrderNumber; Thanks for all your responses !

Check if year is leap year in javascript [duplicate]

function leapYear(year) { return ((year % 4 == 0) && (year % 100 != 0)) || (year % 400 == 0); }

How to change the default time zone in R?

Another way to do it, without changing the whole computer time is using the setenv command like this : Sys.setenv(TZ=’GMT’)

How to get difference between two dates in months using MySQL query?

Month-difference between any given two dates: I’m surprised this hasn’t been mentioned yet: Have a look at the TIMESTAMPDIFF() function in MySQL. 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 … Read more

Calculating difference in dates in Java

Java’s not missing much, if you look at open source: try Joda-Time.

Add a month to a Date [duplicate]

Function %m+% from lubridate adds one month without exceeding last day of the new month. library(lubridate) (d <- ymd(“2012-01-31”)) 1 parsed with %Y-%m-%d [1] “2012-01-31 UTC” d %m+% months(1) [1] “2012-02-29 UTC”

How do I find the time difference between two datetime objects in python?

>>> import datetime >>> first_time = datetime.datetime.now() >>> later_time = datetime.datetime.now() >>> difference = later_time – first_time datetime.timedelta(0, 8, 562000) >>> seconds_in_day = 24 * 60 * 60 >>> divmod(difference.days * seconds_in_day + difference.seconds, 60) (0, 8) # 0 minutes, 8 seconds Subtracting the later time from the first time difference = later_time – first_time … Read more

How to find the duration of difference between two dates in java?

The date difference conversion could be handled in a better way using Java built-in class, TimeUnit. It provides utility methods to do that: Date startDate = // Set start date Date endDate = // Set end date long duration = endDate.getTime() – startDate.getTime(); long diffInSeconds = TimeUnit.MILLISECONDS.toSeconds(duration); long diffInMinutes = TimeUnit.MILLISECONDS.toMinutes(duration); long diffInHours = TimeUnit.MILLISECONDS.toHours(duration); … Read more

Calculate difference between 2 date / times in Oracle SQL

You can substract dates in Oracle. This will give you the difference in days. Multiply by 24 to get hours, and so on. SQL> select oldest – creation from my_table; If your date is stored as character data, you have to convert it to a date type first. SQL> select 24 * (to_date(‘2009-07-07 22:00’, ‘YYYY-MM-DD … Read more

Calculating days between two dates with Java

UPDATE: The original answer from 2013 is now outdated because some of the classes have been replaced. The new way of doing this is using the new java.time classes. DateTimeFormatter dtf = DateTimeFormatter.ofPattern(“dd MM yyyy”); String inputString1 = “23 01 1997”; String inputString2 = “27 04 1997”; try { LocalDateTime date1 = LocalDate.parse(inputString1, dtf); LocalDateTime … Read more