Table 36. Siebel Data Operators
Operator
|
Syntax
|
Properties
|
Number
|
Number( A )
|
Converts the operand to a number. Operand can be an expression.
|
String
|
String( A )
|
Converts the operand to a string. Operand can be an expression.
|
Date
|
Date( A )
|
Converts string to a date. Operand can be an expression.
|
Time
|
Time( A )
|
Converts the operand to a time. Operand can be an expression.
|
UtcDateTime
|
UtcDateTime( A )
|
Converts the operand to the UTC date and time. Operand can be an expression.
|
DateTime
|
DateTime(A)
|
Converts the operand to a date and time. Operand can be an expression. Not recommended for use. Use UtcDateTime instead.
|
Currency
|
Currency( A )
|
Converts the operand to currency. Operand can be an expression.
|
Phone
|
Phone( A )
|
Converts the operand to a phone number. Operand cannot be an expression. Can be used only with Equals (==) and Not Equal To (!=) operators to compare two phone numbers.
|