date()

SQLite functions that do calendar arithmetic and formatting on dates stored as year-month-day text.

In more detail

date('2024-03-01', '+45 days') returns 2024-04-15, counting month lengths correctly, and strftime('%Y', joined) pulls out the year. They only work if the text is in the year-month-day layout.

Example

SELECT date('2024-03-01', '+45 days');

Related terms

Taught in

References