dob - get Teacher Superannuation age in sql query -


thanks in advance : please me out wirting sql query find supperannuation date of of employee have employee wich going 60 years in age on different dates need dates date of birth .

teachername         dateofbirth          teacherage     supperannuationdate(onwhich teacher going 60 yers) ------------------------------------------------------- s. khalid salim 1958-03-23 00:00:00.000  55 zubaida begum   1976-08-01 00:00:00.000  36 tanzeem akhtar  1974-09-25 00:00:00.000  38 maryam bibi     1982-08-18 00:00:00.000  30 rabia tabassum  1976-11-10 00:00:00.000   36 

here query need fourth column name "annunationdate " on teacher age 60 year .

select  teachername ,dateofbirth , datediff(mm, dateofbirth, getdate()) / 12 teacherage  teachers 

------------------------for example @ first row display in fourth column 1963-03-23 00:00:00.000 somthing

sql server

select teachername, dateadd(year, 60 , dateofbirth) superannuationdate teachers 

mysql

select teachername, date_add(dateofbirth, interval 60 year) superannuationdate teachers 

oracle

select teachername, add_years(dateofbirth, 60) superannuationdate teachers 

Comments

Popular posts from this blog

Change php variable from jquery value using ajax (same page) -

Pull out data related to my apps from Android Play Store and iOS App Store -

How can I fetch data from a web server in an android application? -