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 ?