Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use DATEDIFF without leap year?

3417323Mar 18 2017 — edited Mar 19 2017

How to calculate days difference between two dates without leap year(365 days each year)? Thank you so much!

Edit:

I am new to Oracle Community Support, and I assumed that if I posted question in Oracle under SQL and PL/SQL, people would understand what I need.  I didn’t know you answered questions including MySQL and other SQLs. Thank you everyone, and sorry for the confusion.

I was also surprised that I got so many good ideas from you guys. I tested the code using the testing data, and they worked fine. I am going to put the code into the program to test it. Thanks again!

This post has been answered by mathguy on Mar 19 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2017
Added on Mar 18 2017
19 comments
3,476 views