SQLite Date and Time Functions Enhanced: More Powerful Date/Time Manipulation

2025-06-15

SQLite's date and time functions have been enhanced to provide richer functionality. This document details the five core functions: `date`, `time`, `datetime`, `julianday`, and `strftime`, along with various time string formats and modifiers like `unixepoch` and `localtime`, enabling more flexible date/time calculations and formatting. A user-contributed patch is also highlighted, adding numerous features such as `start of week`, `end of day` modifiers, and `group * by` functionality for convenient aggregation.

Development Date/Time Functions