USoft for Sybase

Previous Next

LONG Fields

Querying on LONG fields is supported on Sybase 11 (OpenClient). A wildcard (%) must be used in the query. You should also be careful not to use binary long types, e.g. use LONG instead of LONGRAW.

However, in the Definer you cannot query on LONG fields.

Date Functions

Universal date_to_char and char_to_date functions are available for Sybase. The syntax is:

SELECT date_to_char(<expression>,<format>) FROM <table>

SELECT char_to_date(<expression>,<format>) FROM <table>