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 |