Skip to content

Glossary: SQL Basics

date

Also written: date('now')

A SQLite function that gives a date: `date('now')` is today's date (in UTC), and extra modifier arguments move it, as in `date('2026-10-21', '-30 days')`.

Where the book teaches it

Related terms

ModifierstrftimeUTC (Coordinated Universal Time)