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 |