Top "Date-arithmetic" questions

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

Comparing date with sysdate in oracle

I have a column which is of "DATE" type and I want to run a query on it comparing it …

sql oracle date-arithmetic
Get the number of days between two dates in Oracle, inclusive of the dates

I want to get total number of days between two provided dates. I've tried the below query but didn't get …

oracle oracle11g date-arithmetic
Oracle get records updated in last one hour

Below is the query I am running to get updates in last one hour. select count(*) from my_table where …

sql oracle date-arithmetic
jQuery: pass string variable to date object

I have a page with a number of variables that contain a date in string format (yyyy-mm-dd) which originates from …

javascript jquery datetime momentjs date-arithmetic
Getting Last Day of Previous Month in Oracle Function

I need a function in Oracle like this. When i giving a parameter a simple date. Then function should getting …

database oracle function date-arithmetic
find the elapsed time between two dates in oracle sql

i need to find the difference between the time in the format hh:mm:ss select msglog.id,max(msglog.…

sql oracle date-arithmetic
Number of days between two dates C++

I saw examples for C#, Java, but for C++ i cant find solution to calculate how many days between two …

c++ date date-arithmetic
Comparing dates in Oracle using the decode function

I need to compare two dates using the Oracle decode function to see if one is less than or equal …

sql oracle date decode date-arithmetic
How can I get a date after 15 days/1 month in PHP?

In my PHP code I have a date in my variable "$postedDate". Now I want to get the date after 7 …

php date date-arithmetic
Number of days in a month

I have a monthly amount that I need to spread equally over the number of days in the month. The …

sql oracle plsql date-arithmetic