H2 Database SQL Documentation
SQLDock aims to be the best documentation for any SQL server. I wanted to be able to quickly press Ctrl+K and get examples of
functions available within my database. To also compare what each database offered. Thus SQLDock was born.
String
ascii, bit_length, btrim, char, char_length, concat, concat_ws, difference, hextoraw,
left, locate, lower, lpad, ltrim, octet_length, quote_ident, rawtohex, regexp_like, regexp_replace, regexp_substr, repeat, replace, right, rpad, rtrim, soundex, space, stringdecode, stringencode, stringtoutf8, substring, to_char, translate, trim, upper, utf8tostring, xmlattr, xmlcdata, xmlcomment, xmlnode, xmlstartdoc, xmltext
Math
abs, acos, asin, atan, atan2, ceil, cos, cosh, cot, degrees, exp, floor, greatest, least, ln, log, log10, mod, ora_hash, pi, power, radians, rand, round, sin, sinh, sqrt, tan, tanh, trunc, zero
DateTime
current_date, current_time, current_timestamp, date_trunc, dateadd, datediff, day_of_month, day_of_week, day_of_year, dayname, extract, formatdatetime, hour, iso_day_of_week, iso_week, iso_year, last_day, localtime, localtimestamp, minute, month, monthname, parsedatetime, quarter, second, week, year
Array
array_append, array_cat, array_contains, array_get, array_max_cardinality, array_slice, cardinality, json_array, json_object, trim_array, unnest
Bitwise
bitand, bitcount, bitget, bitnand, bitnor, bitnot, bitor, bitxnor, bitxor, lshift, rotateleft, rotateright, rshift, ulshift, urshift
Config
current_catalog, current_path, current_role, current_schema, current_user, database_path, disk_space_used, h2version, link_schema, lock_mode, lock_timeout, memory_free, memory_used, set
Encryption
compress, decrypt, encrypt, expand, hash, random_uuid, secure_rand, sign
File
csvread, csvwrite, file_read, file_write
Misc
nextval, nullif, nvl2, readonly, rownum, session_id, transaction_id, truncate_value
System
abort_session, autocommit, cancel_session, coalesce, convert, currval, data_type_sql, db_object_id, db_object_sql, decode, estimated_envelope, signal, table