More sqlserver Examples / Practice Programs

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

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.. …

C String Functions

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