More sqlserver Examples / Practice Programs

Write a Query to get only time part of the “AdmissionDate” from tblStudent

Introduction

Write a Query to get only time part of the “AdmissionDate” from tblStudent. 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	2018-06-10	Computer Engineering
2	David	Jones	1200	2018-06-20	Civil Engineering
3	Michael	Johnson	900	2018-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 datepart (YYYY,Admission_date) Admission_Year, datepart (MM,Admission_date)
Admission_Month,COUNT(*) Total_Student FROM tblStudent GROUP BY datepart(YYYY,Admission_date),
datepart(MM,Admission_date)

Result

Write a Query to get only time part of the "AdmissionDate" from tblStudent — Write a Query to get only time part of the “AdmissionDate” from tblStudent

Java Final keyword

Introduction : java final keyword The final keyword present in Java programming language is generally used for restricting the user. …

C++ Memory Management: new and delete

C++ Memory Management We know that arrays store contiguous and the same type of memory blocks, so memory is allocated …