Introduction

Write a SQL query to get admission date and time from tblStudent table. 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 00:00:00	Computer Engineering
2	David	Jones	1200	2016-06-20 00:00:00	Civil Engineering
3	Michael	Johnson	900	2016-08-15 00:00:00	Chemical Engineering
4	Chris	Lee	1500	2018-07-10 00:00:00	Electrical Engineering
5	Mike	Brown	1600	2018-09-10 00:00:00	Mechanical Engineering
6	Lisa	Smith	1800	2018-07-10 00:00:00	Computer Engineering
7	Mary	Smith	1600	2018-06-11 00:00:00	Computer Engineering

SELECT CONVERT(VARCHAR(19), admission_date,121)
FROM tblStudent

Result