Solved

IsDate and IsNumeric functions?

Posted on 1999-01-19
2
1,632 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to query constraints in Sybase 3 1,666
Sybase 2 MS SQL migration/conversion 4 152
Time optimization for insert/update in ultralite. 3 129
Sybase Adaptive server 4 143
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
Knowing where your website is hosted is as important as the features you receive, the monthly fee, and the support you receive. Due diligence should be done when choosing your next hosting provider.
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 …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

776 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