Sun Microsystems Sun StorageTek 5800 - Manual (Page 123)

Examples of Supported Query Expressions
■ {fn LCASE(mp3.artist)} LIKE ’%floyd%’ AND system.object_size > 2000000
■ (object_size < 200) OR "Collation" = ’en-US’
■ {fn TIMESTAMPDIFF(SQL_TSI_YEAR, system.test.type_timestamp, ’2007-04-02
01:50:50.999 ’)} < 3
■ {fn TIMESTAMPADD(SQL_TSI_YEAR, 2, system.test.type_timestamp )} > ’2007-04-03
01:50:50.999 ’
Queries Not Supported in Version 1.1
The following JDBC escapes are not supported:
■ CHAR(code)
■ INSERT(string1, start, length, string2)
■ LEFT(string, count)
■ REPEAT(string, count)
■ REPLACE(string1, string2, string3)
■ RIGHT(string, count)
■ SPACE(count)
■ ROUND(value, number)
■ TRUNCATE(value, number)
■ POWER(value, power)
■ ACOS(float)
■ ASIN(float)
■ ATAN(float)
■ ATAN2(float1, float2)
■ CEILING(number)
■ COS(float)
■ COT(float)
■ DEGREES(number)
■ EXP(float)
■ FLOOR(number)
■ LOG(float)
■ LOG10(float)
■ ASCII(string)
■ MOD(float1, float2)
■ PI()
■ POWER(number, power)
■ RADIANS(number)
■ RAND(integer)
■ SIGN(number)
Queries Not Supported in Version 1.1
Chapter 4 • Sun StorageTek 5800 System Query Language 123