Implicit Data Type Conversions

Sybase CEP automatically converts data types to other data types, expressions to integers, long, and data types to Strings.

Sybase CEP automatically converts certain data types to other data types when necessary. Sybase CEP Engine automatically converts expressions that evaluate to Integer that are destined for a Long or Float function argument, operator argument, or column. Sybase CEP Engine also automatically converts expressions that evaluate to Long that are destined for a Float function argument, operator argument, or column.

Also, if needed and if possible, Sybase CEP Engine automatically converts any other data type to String and from String to any other data type. To implicitly convert to String, Sybase CEP Engine uses TO_STRING(). For Timestamp, the format is YYYY-MM-DD HH24:MI:SS.FF TZD. To implicitly convert from String, Sybase CEP Engine uses the appropriate TO_xxx() function (such as TO_BLOB). For Timestamp, the format is the same. The value Null converts to Null, no matter what the types are. If Sybase CEP Engine detects an ambiguity, then an error is generated.