How can we help you today?
ISDATE -- how to use?
Rob Parker
A quick check of the code finds that it is registered as a reserved word, but there is no implementation for the ISDATE function, currently. I'm not sure how it got included in the list on that web page. The rest of the system functions listed are all supported (and the rest of the list on that page, as far as I noticed in scanning it)--except that FTS optimization of CONTAINS is currently broken in 5.x.
ISDATE is among some other date/time-related functions that we are considering adding support for in 5.2 (planned for late 2015).
If you really need it before then, you might be able to create an implementation in .NET code as a CLR function to use as a workaround.
ISDATE seems still unsupported in current stable version.
Will be present in the future 6.x release?
Rob Parker
We'll look into adding it in 6.x, hopefully in 6.0.
Lisa Kelly
I see here that ISDATE is a system function:
http://www.gibraltarsoftware.com/vistadb/what-you-get/technical/sql-support
However, when I do:
ISDATE(@variable)
and @variable is a varchar variable, it says "Name or alias cannot be reserved word: ISDATE.
Here is the function I was trying to write:
IF (ISDATE(@dateString))
BEGIN
RETURN(@dateString);
END
RETURN NULL;
I assume I must be using ISDATE wrong somehow? What is the proper way to use it?
1 person has this question