Tech Study

Write a SQL query to Get the first name, last name, current date, admission date and difference between current date and admission date in days

Introduction

Write a SQL query to Get the first name, last name, current date, admission date and difference between current date and admission date in days

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

 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
SELECT FirstName, LastName, GETDATE() AS 'Current_date', Admission_date,
DATEDIFF(DD, Admission_date, GETDATE()) AS days FROM tblStudent

Result

Write a SQL query to Get the first name, last name, current date, admission date and difference between current date and admission date in days
Write a SQL query to Get the first name, last name, current date, admission date and difference between current date and admission date in days

Tagged"Last Name"admission date and difference between current date and admission date in dayscurrent dateWrite a SQL query to Get the first name

Python Examples

Introduction: Python Examples are the basic programming concepts of python like python syntax,python data types,,python operators,python if else,python comments etc.. …

Read more

C String Functions

C String Functions perform certain operations, It provides many useful string functions which can come into action. The <string.h> header …

Read more