ISDATE() Problem

• raotor

  Hall of Fame

  Points: 3346

  More actions

  December 21, 2011 at 4:41 am

  #247967

  Hello,

  I was looking for a function to validate a date type variable and came

  across the ISDATE() function. However, I was attempting to use this in

  conjunction with the newly added (as of SS2008 I believe) DATE data type.

  e.g

  DECLARE @MyDate DATE = GETDATE();

  IF ISDAT(@MyDate) = 1

  PRINT 'Date OK';

  This resulted in an error which during trial and error appeared to simply

  be down to the fact that the newly added data types of DATE and DATETIME2 do

  not appear to be supported by the ISDATE() function.

  Has Microsoft forgotten about these new date types?

  It would appear that they should indeed be supported in order to retain

  consistency going forward, or have I missed the point?

  Comments or advice welcome.

  Steve

• davidandrews13

  SSCertifiable

  Points: 6809

  More actions

  December 21, 2011 at 4:56 am

  #1424137

  it seems that the ISDATE function doesn't support those data types by design.

  https://connect.microsoft.com/sql/feedback/ViewFeedback.aspx?FeedbackID=327335

  i got that link from here: http://dhaneenja.blogspot.com/2010/11/isdate-function-doesnt-validate-date.html

• salum

  SSCommitted

  Points: 1598

  More actions

  December 21, 2011 at 5:12 am

  #1424145

  BOL is also stating same.

  http://technet.microsoft.com/en-us/library/ms187347.aspx

  java[/url]

• raotor

  Hall of Fame

  Points: 3346

  More actions

  December 21, 2011 at 5:57 am

  #1424168

  Thanks for the links.

  I read the comments and Microsoft's response and I'd have to say that their stance was pretty weak.