Literalsfor 5800 System Data Types
Foreach 5800 system data type, there is a syntax to include literals of that type in a query string.
Thesyntax is {type_name ’stringliteral’}. For example, consider the query:
timestamp_field<{timestamp ’2006-10-26T12:00:00Z’}
Inparticular, this syntax can be used to query for a particular object ID:
system.object_id = {objectid
’0200011e61c159bdfa654e11db8a45cafecafecafe000000000200000000’}
Forcomparing against binary values, either of the following forms may be used:
binary_field = x’beeffeed’
binary_field = {binary ’beeffeed’}
Formore information, see “Canonical String Format” on page 119.
Canonical String FormatEachtype in a 5800 system has a canonical representation as a string value. The canonical
stringrepresentation of each type is shown in Table 4–1.
TABLE4–1 CanonicalString Representation of Data Types
DataType CanonicalStringRepresentation
STRING Thestring itself.
CHAR Thestring itself.
BINARY Hexadecimaldump of the value with two hex digits per byte.
LONG Resultof Long.toString. For example, 88991 or -7975432785.
DOUBLE Resultof Double.toString. For example, 1.45 or NaN or -Infinity or -1.56E200.
DATE YYYY-mm-dd.For example, 2001-01-01.
TIME HH:mm:sss.For example, 12:02:01.
TIMESTAMP YYYY-mm-ddThh:mm:ss.fffZ(time relative to UTC). For example,
1969-12-31T23:59:59.999Z.
OBJECTID 60-digithexadecimal dump of the objectid.
Thiscanonical string encoding is used in the following places:
■Whenexposing the eld as a directory component or a lename component in a virtual view
CanonicalStringFormat
Chapter4 • Sun StorageTek 5800 System Query Language 119