Solved

IsDate and IsNumeric functions?

Posted on 1999-01-19
2
1,624 Views
Last Modified: 2012-06-27
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.
0
Comment
Question by:jsullivan
2 Comments
 

Author Comment

by:jsullivan
ID: 1098560
Edited text of question
0
 
LVL 10

Accepted Solution

by:
bret earned 100 total points
ID: 1098561
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.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In 2017, ransomware will become so virulent and widespread that if you aren’t a victim yourself, you will know someone who is.
A customer recently asked me about anti-malware and the different deployment options available for his business. Daily news about cyberattacks, zero-day vulnerabilities, and companies that suffered a security breach made him wonder if the endpoint a…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now