HarperDB SQL Functions
This SQL keywords reference contains the SQL functions available in HarperDB.
| Keyword | Description |
|---|---|
| ABS | |
| AVG | |
| BETWEEN | |
| CASE | |
| CAST | |
| CEIL | |
| COALESCE | |
| CONCAT | |
| CONCAT_WS | |
| CONVERT | |
| COUNT | |
| CURRENT_DATE | |
| CURRENT_TIME | |
| CURRENT_TIMESTAMP | |
| DATE | |
| DATE_ADD | |
| DATE_DIFF | |
| DATE_FORMAT | |
| DATE_SUB | |
| DAY | |
| DAYOFWEEK | |
| DELETE | |
| DISTINCT | |
| EXISTS | |
| EXP | |
| EXTRACT | |
| FLOOR | |
| FROM | |
| GETDATE | |
| GET_SERVER_TIME | |
| GROUP BY | |
| GROUP_CONCAT | |
| HAVING | |
| HOUR | |
| IF | |
| IFNULL | |
| IIF | |
| IN | |
| INNER | |
| INSERT | |
| INSTR | |
| INTERVAL | |
| IS NOT NULL | |
| IS NULL | |
| ISNULL | |
| LEFT OUTER | |
| LEN | |
| LIKE | |
| LIKE Escape Character | |
| LOWER | |
| LTRIM | |
| MAX | |
| MEDIAN | |
| MIN | |
| MINUTE | |
| MONTH | |
| NOW | |
| NULL | |
| NULLIF | |
| OFFSET_UTC | |
| QUART | |
| QUART2 | |
| QUART3 | |
| RANDOM | |
| REGEXP | |
| REGEXP_LIKE | |
| REPLACE | |
| RIGHT OUTER | |
| ROUND | |
| ROWNUM | |
| RTRIM | |
| SECOND | |
| SELECT | |
| SPRINTF | |
| SQRT | |
| STD | |
| STDDEV | |
| STDEV | |
| STDEVP | |
| SUBSTRING | |
| SUM | |
| TRIM | |
| UPDATE | |
| UPPER | |
| VAR | |
| VARP | |
| WHERE | |
| YEAR |