Home » MCQs » SQL MCQs » SQL Comments, Group By, Cast Function MCQs

What will be the output of the below SQL statement (2)?

12. What will be the output of the below SQL statement?

SELECT CAST('2021-10-06' AS datetime);

1. 2021-10-06 00:00:00.000
2. 2021-10-06
3. 2021 OCT 06
4. 06-10-2021

Answer: A) 2021-10-06 00:00:00.000

Explanation:

This statement converts the value to a datetime datatype.