Check if Value in Column is Date in SQL Server

Updated on August 30, 2015 Kisan Patel

This tutorial will show you how to check for validate date in SQL Server?

To check for a valid date, we can use ISDATE function by passing the date string or a date value.

SELECT
ISDATE('15/16/2015') InValidDate,
ISDATE(GETDATE()) ValidDate

SQL Server

« Previous

You must be logged in to post a comment.

Tutorials

This tutorial will show you how to convert a column value from one data type to another in SQL Server? […]

This tutorial will show you how to trim unnecessary space from the string in SQL Server? To trim unnecessary blank […]

This tutorial will explain you how to get data in XML format from SQL server database. To get data in […]

To specify see value and increment value to the auto increment column in the existing database table, we pass parameter […]

This tutorial will show you how to use IF condition in SQL Server? If condition works in SQL server in […]