Question

Which of the following function checks whether the expression is a valid date or not?

(a) ISDATE

(b) ISDAY

(c) ISVALID

(d) ISYEAR

I had been asked this question in examination.

I'd like to ask this question from Builtin Functions in section Laying the Foundation of SQL Server

Answer 1

The correct answer is (a) ISDATE

To explain I would say: ISDATE() determines whether a datetime or smalldatetime input expression is a valid date or time value.