Is there a function like isdate() for the data type datetime2 in sql server 2008?
I know there is a function called isdate() to validate datetime columns, but it works only for the smalldatetime and datetime types.
The question is: is there a similar way to validate the new data type datetime2 in sql server 2008 and 2012?
Is there a function like isdate() for the data type datetime2 in sql server 2008?
===

I know there is a function called isdate() to validate datetime columns, but it works only for the smalldatetime and datetime types.
The question is: is there a similar way to validate the new data type datetime2 in sql server 2008 and 2012?