Skip to main content

bSQL functions

bSQL offers a suite of functions to be used over columns when querying data.

Categories of bSQL functions

FUNCTION CATEGORYDESCRIPTION
Logical FunctionsPerform logical operations.
Mathematical FunctionsPerform calculations based on input values provided as parameters to the functions, and return numeric values.
String FunctionsPerform operations on a string input value and return a string or numeric value.
Timestamp FunctionsPerform operations on a timestamp input values and return string, numeric, or date and time values.
Conversion FunctionsSupport data type casting and converting.
Aggregate FunctionsPerform a calculation on a set of values and return a single value.
Cryptographic FunctionsThese functions support digital signing, digital signature validation, encryption, and decryption.

Example Blockchain

For the purpose of the doc examples we will be using the following blockchain called example:

INTEGER [INT32]STR [STRING]REAL [FLOAT32]TIME [TIMESTAMP]B [BOOL]
-1NULLNULLNULLNULL
0d02007-01-02 07:04:05.000000002false
1lect12007-01-03 07:04:05.000000002true
2dialect22007-01-04 07:04:05.000000002false

string-functions