Top "Date-arithmetic" questions

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

Subtracting n Days from a date using SQL

I am quite a beginner when it comes to Oracle. I am having trouble figuring out how to do something …

sql oracle date-arithmetic oracle8i
MySQL how to fill missing dates in range?

I have a table with 2 columns, date and score. It has at most 30 entries, for each of the last 30 days …

mysql sql recursive-query gaps-and-islands date-arithmetic
Print the time an hour ago

Possible Duplicate: Given a time, how can I find the time one month ago How can I print an hour …

php string date time date-arithmetic
oracle query between two dates with hours

This is my current oracle table: DATE = date HOUR = number RUN_DURATION = number I need a query to get RUN_…

sql oracle date-arithmetic
Add Day to Timestamp

How do I add days to a timestamp? If my timestamp is 01-JAN-2011 11-09-05 and I add 2 days, I …

sql oracle timestamp date-arithmetic
How to subtract years?

I have a date in R, e.g.: dt = as.Date('2010/03/17') I would like to subtract 2 years from …

r date date-arithmetic r-faq
How to change the default time zone in R?

How can I change the default timezone in R? I'm working with time series. All my time series are defined …

r timezone date-arithmetic
SQL: Get records created in time range for specific dates

I have a set of records that were created last week, and from those I want to retrieve only those …

sql oracle date-arithmetic
Easy way to get day number of current quarter?

PHP provides ways to get the number of the current day of the month (date('j')) as well as the …

php date date-arithmetic
Arithmetics on calendar dates in C or C++ (add N days to given date)

I have been given a date, Which I am taking as an input like (day, month, year): 12, 03, 87. Now I need …

c++ c date date-arithmetic