Datatype Assignment to a Bind Variable
In queries, the type of a bind variable is enforced by its surrounding expression. In the query, use the specific expressions to assign the desired type to the bind variable.
Datatype | Expression |
---|---|
int long
|
( + 0) |
double
|
( + .0) |
String
|
( || ) |
Boolean
|
( or false) |
DateTime
|
Note
:
DateTime is not supported so use the following instead.
Pass a
Pound or hash (#) is the escape character. See Keywords and Other Reserved Words. |