Write a Query to get the first name, last name, current date, admission date and difference between current date and admission date in year

Write a Query to get the first name, last name, current date, admission date and difference between current date and admission date in year

Introduction

Write a Query to get the first name, last name, current date, admission date and difference between current date and admission date in year. I have used Microsoft SQL server 2008 R2 for the following demo.


techstudy.org

Kindle Paperwhite High Resolution Display Tablet | Rs. 9999

- tblstudent

StudentId FirstName LastName Admission_fee Admission_date Branch
1 John Smith 1000 2016-06-10 Computer Engineering
2 David Jones 1200 2016-06-20 Civil Engineering
3 Michael Johnson 900 2016-08-15 Chemical Engineering
4 Chris Lee 1500 2018-07-10 Electrical Engineering
5 Mike Brown 1600 2018-09-10 Mechanical Engineering
6 Lisa Smith 1800 2018-07-10 Computer Engineering
7 Mary Smith 1600 2018-06-11 Computer Engineering
  1. SELECT FirstName, LastName, GETDATE() AS 'Current_date', Admission_date,
  2. DATEDIFF(YYYY, Admission_date, GETDATE()) AS years FROM tblStudent

Result

sql server techstudy.org

     





Related Topics


Responses




Popular Posts

Facebook

Founded in 2016, Tech Study passionately delivers stylish and dynamic innovative information to programmer and technology lovers. http://www.techstudy.org/.