Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » CursorRSS Feeds

Display number of months from joining date to birth date of programmer

Posted By: Raimundo Fischer     Category: Oracle     Views: 4984

Display number of months from joining date to birth date of programmer.

Code for Display number of months from joining date to birth date of programmer in Oracle

SELECT NAME, MONTHS_BETWEEN(DOJ,DOB) "AGE" FROM PROGRAMMER;

NAME           AGE
-------- ---------
ANAND 312 ALTAF 309.6129 HAGDISH 239.93548 JULIANA 266.67742 KAMALA 278.09677 MARY 231.25806 NELSON 289 PATRICK 293.06452 QADIR -28.32258 RAMESH 285.80645 REBECCA 287 REMITHA 276.03226 REVATHI 265 VIJAYA 316.6129
  
Share: 



Raimundo Fischer
Raimundo Fischer author of Display number of months from joining date to birth date of programmer is from Frankfurt, Germany.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!