Working with dates in SQLite and Grafana

SQLite can be used as a data source for Grafana using a community plugin maintained by fr-ser. Out of the box the plugin has support for time formatted columns, which work on visuals like time series, and time range macros, which use the dashboards datetime picker. This post has a few of my notes. Unix epoch numbers (e.g. 1773149763) and RFC3339 strings (e.g. 2026-03-10T15:36:03+01:00) work natively for time formatted columns. The documentation has an example of how to fix malformed RFC3339 s...