Top "Date-arithmetic" questions

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

Calculate difference between 2 date / times in Oracle SQL

I have a table as follows: Filename - varchar Creation Date - Date format dd/mm/yyyy hh24:mi:ss …

oracle date-arithmetic
How do I find the time difference between two datetime objects in python?

How do I tell the time difference in minutes between two datetime objects?

python datetime date-arithmetic
Calculating days between two dates with Java

I want a Java program that calculates days between two dates. Type the first date (German notation; with whitespaces: "dd …

java date-arithmetic
Oracle DateTime in Where Clause?

I have sql something like this: SELECT EMP_NAME, DEPT FROM EMPLOYEE WHERE TIME_CREATED >= TO_DATE('26/JAN/2011…

sql oracle time date-arithmetic
Oracle date "Between" Query

I am using oracle database. i want to execute one query to check the data between two dates. NAME START_…

sql oracle oracle10g where-clause date-arithmetic
How to find the duration of difference between two dates in java?

I have two objects of DateTime, which need to find the duration of their difference, I have the following code …

java date-arithmetic
How can I do time/hours arithmetic in Google Spreadsheet?

How do I do time/hour arithmetic in a Google spreadsheet? I have a value that is time (e.g., 36:00:00) …

time google-sheets datetime-format date-arithmetic
Oracle: how to add minutes to a timestamp?

I need to add 30 minutes to values in a Oracle date column. I do this in my SELECT statement by …

oracle date timestamp date-arithmetic
The difference in months between dates in MySQL

I'm looking to calculate the number of months between 2 date time fields. Is there a better way than getting the …

mysql date datediff date-arithmetic
sql delete statement where date is greater than 30 days

I need a SQL statement to delete row that are older than 30 days. My table events has a field date …

sql-server date-arithmetic