web analytics

Tagged: datediff

Calculating difference of dates in Oracle 0

Calculating difference of dates in Oracle

Reading Time: 1 minuteHow to calculate difference between two dates in oracle, as subtraction of dates returns numeric value as difference. With some slight changes/enhancements we can track back the subtraction values to some readable date formats:...

Find week start/end given week number 0

Find week start/end given week number

Reading Time: 1 minuteI have a table with some dated records. I wanted to do some weekly reports on this data. MySQL has a nifty function dubbed WEEK() which will return a week number. It allows you...

How To Calculate the Number of Week Days Between two Dates 1

How To Calculate the Number of Week Days Between two Dates

Reading Time: 1 minuteIf the start date and end date are both week days, then the total number of week days in between is simply: (total difference in days) – (total difference in weeks) * 2 DateDiff(dd,...