Functions

Index

Numeric Functions

${item.topic}
${item.topic}
${item.topic}

String Functions

${item.topic}
${item.topic}
${item.topic}

Time and Date Functions

${item.topic}
${item.topic}
${item.topic}

System Functions

${item.topic}
${item.topic}
${item.topic}

JSON Functions

${item.topic}
${item.topic}
${item.topic}

Table Functions

${item.topic}
${item.topic}
${item.topic}

Details

Click on the header of the function to switch between railroad diagram and BNF.

Non-standard syntax is marked in green. Compatibility-only non-standard syntax is marked in red, don't use it unless you need it for compatibility with other databases or old versions of H2.

Numeric Functions

${item.topic}

${item.syntax}
${item.railroad}

${item.text}

Example:

${item.example}

String Functions

${item.topic}

${item.syntax}
${item.railroad}

${item.text}

Example:

${item.example}

Time and Date Functions

${item.topic}

${item.syntax}
${item.railroad}

${item.text}

Example:

${item.example}

System Functions

${item.topic}

${item.syntax}
${item.railroad}

${item.text}

Example:

${item.example}

JSON Functions

${item.topic}

${item.syntax}
${item.railroad}

${item.text}

Example:

${item.example}

Table Functions

${item.topic}

${item.syntax}
${item.railroad}

${item.text}

Example:

${item.example}