Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Write a query to calculate the year difference

Posted By: Arnelle Schmidt     Category: Oracle     Views: 2742

Write a query to calculate the year difference.

Write a query to calculate the year difference

SELECT months_between (SYSDATE,DOB)/12 FROM PSTUDENT;

Output : 

MONTHS_BETWEEN(SYSDATE,DOB)/12
                     14.113978
                    14.554838
                    13.847849
                    14.600537
                     17.18387
                    17.100537
                    13.764515
  
Share: 


Didn't find what you were looking for? Find more on Write a query to calculate the year difference Or get search suggestion and latest updates.

Arnelle Schmidt
Arnelle Schmidt author of Write a query to calculate the year difference 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!