Type conversion in SolFS query language
See alsoOverview
When SolFS parses the queries, all operands are converted to the same type if it is possible. The conversion is performed to the type of the leftmost term. If it is not possible, and operand to the right has type String, the operand to the left is converted to String.
Conversion of data to different types:
Conversion to:
Conversion of:
Description
String
Number, Boolean, NULL
Usual conversion rules. Conversion of boolean data results in 'True' or 'False'.
DateTime
In string representation, DateTime values follow the pattern: 'YYYY-MM-DD HH:MM:SS.fff'
Boolean
String
'True' and 'False' are recognized correspondingly
DateTime
String
Conversion is performed by the pattern: 'YYYY-MM-DD HH:MM:SS.fff'.
Separator '-' in date is optional. If this symbol is omitted, month and day values must consist of two digits each. If the separator is present, month and day may be represented by one digit.
Date is also optional, time and date may be separated with symbols: ' ' (space), 'T', 't', or there may be no separator.
Time may be represented with: hours only; hours and minutes; hours, minutes and seconds; hours, minutes, seconds and milliseconds.
The ':' separator is optional, if it is not present, time elements must consist of two digits. If it is present, time elements may consist of one digit.
Milliseconds must be always separated with '.' symbol, and must consist of 3 digits.
To explicitly convert String to DateTime, operator D may be used.
Number
String
Decimal signed integers are recognized