Category: DATETIMEOFFSET

ISDATE() function returns 0 for valid DATETIMEOFFSET values?

Quite confusing but true. I was working on trying to validate a specific value if it is indeed a valid DATETIMEOFFSET data type using the ISDATE() function until I saw this forum post “Adam, The problem is that ISDATE returns 0 for valid DATETIMEOFFSET values.” I couldn’t believe it since Books Online until I tested […]