Functions
Functions in dbwql
Numeric functions
Function name | Description |
---|---|
add | Adds a number to a base value |
sub | Substracts a number from a base value |
abs | Returns the absolute value of a number |
until | Return all numbers from a base number until an end number |
Aggregate functions
Function name | Description |
---|---|
groupby | Groups a set on some value(s) |
count | Counts the number of rows |
sum | Adds all values in a set |
avg | Computes the average of set |
max | Finds the max value in a set |
min | Finds the minimum value in a set |
String functions
Function name | Description |
---|---|
upper | Converts a string to uppercase |
lower | Converts a string to lowercase |
trim | Strips empty spaces from the beginning and end of a string |
concat | Concats a number of strings |
capitalize | Capitalizes a string |
Generic functions
Function name | Description |
---|---|
todate | Converts a value to datestring |