Why below statement giving the error and not considering as datetime.Please advise.
Msg 242, Level 16, State 3, Line 1
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
declare @snapshotdate datetime='24-03-2016 00:00:00'
select isdate('24-03-2016 00:00:00') -- This is giving as 0