Q:

Get first name, admission year, admission month and admission date from tblStudent table.

YasminRadwan26
Save to bookmark
|
2022-05-13
|
  616 
0

Get first name, admission year, admission month and admission date from tblStudent table.

Database, Sql programming, Interview questions, Database Interview-questions, Sql programming Interview-questions,
login and add your own answer to this question

All Answers

YasminRadwan26
2022-05-13
need an explanation for this answer? contact us directly to get an explanation for this answer 

select SUBSTRING (convert(varchar,admission_date,103),7,4) as Year,
SUBSTRING (convert(varchar,admission_date,100),1,3) as Month, 
SUBSTRING (convert(varchar,admission_date,100),5,2) as Date
from tblStudent

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now