Find Non Date in Column using IsDate

Suppose We have Employee Table with Hiring Date and HiringDate is with Data Type Nvarchar.
We want to find out which one is non date in Hiring Column ?

Find Non-Date Part from Column using SQL Query IsDate


Select * from Employee
Where IsDate(JoiningDate) = 0

Find Date Part from Column using SQL Query IsDate

Select * from Employee
Where IsDate(JoiningDate) = 1