Type conversion in SolFS query languageSee also
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:
Number, Boolean, NULL
Usual conversion rules. Conversion of boolean data results in 'True' or 'False'.
In string representation, DateTime values follow the pattern: 'YYYY-MM-DD HH:MM:SS.fff'
'True' and 'False' are recognized correspondingly
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.
Decimal signed integers are recognized