SQLite DATETIME Functions
SQLite DATETIME Functions is a SQL function in the SQLite Specific category. SQLite has a compact set of date/time functions: date(), time(), datetime(), julianday(), strftime(). It accepts see syntax. It returns date/time result. A close relative is AUTOINCREMENT (SQLite), which sQLite: unlike AUTO_INCREMENT in MySQL, only INTEGER PRIMARY KEY columns auto-increment. AUTOINCREMENT guarantees unique increasing IDs. A close relative is ROWID / _ROWID_, which sQLite: every row has an implicit 64-bit ROWID. INTEGER PRIMARY KEY becomes an alias for ROWID. A close relative is ATTACH DATABASE, which sQLite: connects another database file to the current connection, allowing cross-database queries. More about this category: SQLite-specific features — AUTOINCREMENT, ATTACH, VACUUM, PRAGMA, ROWID. Related SQLite Specific entries: AUTOINCREMENT (SQLite), ROWID / _ROWID_, ATTACH DATABASE, PRAGMA, VACUUM (SQLite), EXPLAIN QUERY PLAN (SQLite), JSON Functions (SQLite), CREATE VIRTUAL TABLE (FTS5). This page is part of the free SQL Reference documentation covering 762+ statements, functions, and clauses, each with syntax, parameters, return values, and examples for MySQL, PostgreSQL, SQL Server, and SQLite.