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
Post a Comment