Monday, 14 November 2016

SQL SERVER DATE VALIDATION FORMULA

SQL SERVER DATE VALIDATION FORMULA

-- EXAMPLE 1

SELECT ISDATE(GETDATE()) AS [IsDate1];

-- EXAMPLE 2

SELECT ISDATE(1) AS [IsDate2]

-- RESULT 1 = TRUE (Yes), AND 0 = FALSE (No)

No comments:

Post a Comment