<p>This discovery brought to you by the rusqlite crate, whom I thought was doing it wrong, but it turns out the standard is just not great: <a href="https://github.com/rusqlite/rusqlite/blob/844842d311353e7ed17d8ebe47af3db866da7087/src/types/time.rs#L54" target="_blank" rel="nofollow noopener noreferrer" translate="no"><span class="invisible">https://</span><span class="ellipsis">github.com/rusqlite/rusqlite/b</span><span class="invisible">lob/844842d311353e7ed17d8ebe47af3db866da7087/src/types/time.rs#L54</span></a></p>