sqlite_version

The sqlite_version() function returns the text represented the version number of the SQLite library e.g., 3.8.10.

The sqlite_version is an SQL wrapper of the sqlite3_libversion() C-interface.

Syntax

sqlite_version()Code language: SQL (Structured Query Language) (sql)

Arguments

The sqlite_version takes no arguments.

Return Type

TEXT

Examples

The following statement returns the current version of the SQLite library:

SELECT sqlite_version() AS version;
Code language: SQL (Structured Query Language) (sql)
version
-------
3.8.10
Was this tutorial helpful ?