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 alter / modify a stored procedure in SQL Server? To alter the stored […]

This tutorial will show you how to create a User defined scalar function in SQL Server? To create a scalar […]

This example will show you how to create AFTER UPDATE triggers in SQL Server? CREATE TRIGGER UPDATETrigger ON [NORTHWND].[dbo].[Region] AFTER […]

This tutorial will show you how to get a part of string from a sentence in SQL Server? To get […]

This tutorial will show you how to create stored procedure to delete a record from the SQL Server database? CREATE […]