Q:

Show “AdmissionDate” in “yyyy/mm/dd” format, ex- “2016/05/06”.

0

Show “AdmissionDate” in “yyyy/mm/dd” format, ex- “2016/05/06”.

All Answers

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

select CONVERT(varchar(30), admission_date, 111) from tblStudent

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

total answers (1)

Top 100 SQL server queries Interview questions

This question belongs to these collections

Similar questions


need a help?


find thousands of online teachers now
Show only time part of the “AdmissionDate” fr... >>
<< Show “AdmissionDate” in “dd mmm yyyy” form...