Get the first name, last name, current date, admission date and difference between current date and admission date in year.

YasminRadwan26

Save to bookmark

2022-05-13

551

Database, Sql programming, Interview questions, Database Interview-questions, Sql programming Interview-questions,

YasminRadwan26

2022-05-13

need an explanation for this answer? contact us directly to get an explanation for this answer

select FirstName, LastName, GETDATE() as 'Current_date', Admission_date,
DATEDIFF(YYYY, Admission_date, GETDATE()) As years from tblStudent

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)