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: 3053

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!