Built-in SQL Functions - Work formatting, data type conversion, ...

SQL functions are functions that operate on data (columns) to deal with data types conversions, extract text strings and dates, formatting and much more!

You can see some of them in action from SQL built-in console in Jira: Click on the Examples link, then on the Tricks link and Run it.

Native Functions

SQL+JQL is really H2 therefore you can use almost all the H2 functions described in the product documentation:


Custom Functions

SQL+JQL also supports some built-in functions to deal with specific Jira data and formats.