Select from following answers:- This function is used to check whether the specified value is a valid date or not.
- This function returns 1 if the input value is a valid date otherwise it returns 0.
- The return value of IsDate depends on the settings set by SET DATEFORMAT,SET LANGUAGE and default language option.
- All of the above
- All Above
Above all statement is correct about IsDate function as it's also an in-built function used to check valid date.
If the supplied value in not a date or something then it does not throws any error.
For Example:-
select ISDATE(getdate()); --1
select ISDATE('2014-11-05'); --1
select ISDATE('vishal'); --0
select ISDATE('15/13/2014'); --0
this is due to the date format
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator