ORACLE : How to Show / Get, Year Month and Date between two date ?

Use bellow sql to show year month and date :

SELECTÂ Â Â TRUNC (MONTHS_BETWEEN (:END_DATE, :START_DATE) / 12) as YEARS,
MOD(TRUNC (MONTHS_BETWEEN (:END_DATE, :START_DATE)), 12) as MONTHS,
(Â TO_DATE (:END_DATE)- ADD_MONTHS (:START_DATE,TRUNC (MONTHS_BETWEEN (:END_DATE, :START_DATE))))Â as Date
FROM DUAL;

*********************************************************************************************************************
Note : Please not do make backups before using these queries and also confirm them yourself or by aother means as
 well.
*********************************************************************************************************************

Comments

comments

Tags: date, get, month, Oracle, Show, year

This entry was posted on Monday, January 28th, 2013 at 12:01 am and is filed under Oracle Queries. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

6 Responses to “ORACLE : How to Show / Get, Year Month and Date between two date ?”

Doogi says:

March 4, 2013 at 4:27 am

Hmm, now this is going to get interesting. One thing for sure Oracle dbasataes and Sun Solaris go together like peanut butter and jelly. I wonder what will happen to their virtualization efforts, since each has a Xen-based hypervisor that has yet to take off.

Reply
Sheila says:

March 25, 2013 at 2:41 pm

What’s up, after reading this amazing paragraph i am as well glad to share my knowledge here with friends.

Reply
Ben says:

October 8, 2013 at 4:10 am

thanks !

Reply
suzan says:

November 3, 2013 at 2:40 am

Hi, I do believe this is an excellent website. I stumbledupon it 😉 . Money and freedom is the best way to change, may you be rich and continue to guide other people.

Reply
Jack says:

November 3, 2013 at 4:11 pm

thanks!!

Reply
Tim says:

November 3, 2013 at 4:12 pm

Can you share more queries ??

Reply

POiSON WORLD