Top "Date-arithmetic" questions

The term 'date-arithmetic' refers to determining via code such information as how many days, hours, etc.

Oracle Date - How to add years to date

I have a date field DATE = 10/10/2010 sum = 4 (this are number of years by calculation) is there a way to add …

oracle oracle10g date-arithmetic
Oracle SQL Where clause to find date records older than 30 days

I want to find records in a (Oracle SQL) table using the creation date field where records are older than 30 …

sql oracle date-arithmetic
How to subtract hours from a date in Oracle so it affects the day also

I'm trying to subtract date from Oracle so it even effect the day as well. For example, if the timestamp …

sql oracle date-arithmetic
How to calculate an age based on a birthday?

Possible Duplicate: How do I calculate someone’s age in C#? I want to write an ASP.NET helper method …

c# asp.net-mvc date-arithmetic
Get the difference between two dates both In Months and days in sql

I need to get the difference between two dates say if the difference is 84 days, I should probably have output …

sql oracle date-arithmetic
MySQL Select last 7 days

I read some Posts here and seems like nothing special but I can not still select the entries of the …

mysql sql where-clause date-arithmetic
Add a month to a Date

I am trying to add a month to a date i have. But then its not possible in a straight …

r date date-arithmetic
Check if year is leap year in javascript

function leapYear(year){ var result; year = parseInt(document.getElementById("isYear").value); if (years/400){ result = true } else if(years/100){ result = false } …

javascript date conditional-statements date-arithmetic
How to subtract 2 dates in oracle to get the result in hour and minute

I want to subtract 2 dates and represent the result in hour and minute in one decimal figure. I have the …

sql oracle date-arithmetic
Calculate business days in Oracle SQL(no functions or procedure)

I am trying to calculate business days between two dates in Oracle select. I got to the point when my …

sql oracle11g date-arithmetic