SQLite Function Reference

Browse SQLite function references by category: core, string, date and time, math, JSON, aggregate, window, and system functions.

For practical guidance on storing JSON as text or SQLite JSONB, read SQLite JSONB: When and How to Use It.

To run a query without connecting to a server, use the temporary SQLite SQL playground.