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.
|
