HarperDB SQL Functions

This SQL keywords reference contains the SQL functions available in HarperDB.

KeywordDescription
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