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