|
Execute the following
Microsoft SQL Server T-SQL scripst in SSMS Query Editor to validate a date. It returns TRUE or
FALSE (1 or 0):
SELECT ISDATE('01/06/2008')
-- 1
SELECT ISDATE(20101231)
-- 1
SELECT ISDATE(GETDATE())
-- 1
SELECT ISDATE(CURRENT_TIMESTAMP)
-- 1
SELECT ISDATE('01/32/2012')
-- 0
SELECT DateCheck=Convert(varchar,CURRENT_TIMESTAMP) + ' IS A VALID DATE'
WHERE ISDATE(CURRENT_TIMESTAMP) = 1
-- Aug 16 2011 7:46AM IS A VALID DATE
-- ISDATE is language setting dependent
SELECT ISDATE('21/6/2012')
-- 0
SET LANGUAGE british
-- Changed language setting to British.
SELECT ISDATE('21/6/2012')
-- 1
Related article:
http://www.sqlusa.com/bestpractices/datetimeconversion/
BOL: ISDATE (Transact-SQL)
|
