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 ?