• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1692
  • Last Modified:

IsDate and IsNumeric functions?

Does Sybase System 11 have functions which are equivalent to Microsoft SQL Server's IsDate and IsNumeric functions?  In MS SQL Server you can pass a text string to IsDate and find out if it is valid before you try to do a convert() on it.
1 Solution
jsullivanAuthor Commented:
Edited text of question
No, ASE 11.x does not have IsDate() or IsNumeric() functions.

About the closest you can get to IsDate() is to use "set arithabort off" and then use convert().  If you get an error returned, then it is not a valid date.

The next release (12.0) is expected to support JAVA within the server, which will allow you to write your own functions.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now