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

January 28th, 2013, posted in Oracle Queries
Share

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.
*********************************************************************************************************************
Share

Hijab Girl Begins

January 27th, 2013, posted in COMiCS, GiRLs
Share

I saw these comics online..
And I had to share..
Though I dont totally support the concept.
But the good work that is been done needed to be shared and should be appreciated.

1-hijab-girl comic,2-hijab-girl3-hijab-girl4-hijab-girl5-hijab-girl6-hijab-girl7-hijab-girl8-hijab-girl9-hijab-girl10-hijab-girl11-hijab-girl12-hijab-girl13-hijab-girl14-hijab-girl15-hijab-girl16-hijab-girl17-hijab-girlThe hijab girl begins

Share

Being Left Alone, With My Mind, Is Actually Quite Dangerous

January 26th, 2013, posted in COMiCS, MESSAGEs
Share

alone,,mind,dangerous,Being Left Alone, With My Mind, Is Actually Quite Dangerous

Share

Saying Of Bibi Zainabs In Yazeed Court

January 25th, 2013, posted in Islamic Teachings, Muharram
Share

Saying Of Bibi Zainab's In Yazeed Court,Saying,Bibi Zainab,Yazeed ,ImamHussain ,islam,muslims,mulsim,karbala

Share

It Only Gets Better After The Strom

January 24th, 2013, posted in Art, GiRLs
Share

the strom clears it

Share