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

How to resolve disk IO performance problems that are a very important point for SQL Server troubleshooting. Find Average read […]

This tutorial will show you how to return Day name of the week, day of the week, and month name […]

Problem: SQL Server: Database stuck in “Restoring” state Solution: You need to use the WITH RECOVERY option, with your database […]

Problems: How to convert Visual Foxpro database into SQL Server database? How to Import dBase Database into SQL Server? Import […]

This tutorial will show you how to create a Table-valued function in SQL Srever? As explained above, a table-valued function […]