On Tue, Sep 10, 2019 at 1:27 PM Keith Medcalf <kmedc...@dessus.com> wrote:
> Also, note that you have to use the 'unixepoch' modifier with the time > function so that it knows the value is seconds, not days, since floats are by default days and integers are by default > seconds. [...] In my quick reading of the doc [1], I didn't pickup any such mention. Is it even there? The 'unixepoch' modifier tells the internal datetime functions that the > provided value is relative to the unix epoch in seconds, rather than the > julian epoch in days. I don't think there is a modifier to force the days from the julian epoch > interpretation. > See above. Not super-clear from the doc. As DRH mentioned recently about a different piece of doc, I suspect that doc hasn't been updated in years, and could use some attention IMHO. It's not specified what the various functions return in terms of types for example. It reads more like a terse user manual than reference documentation. Note sure how to make it more approachable exactly, but it seems hard to grasp exactly what's going on, at least to me. FWIW. --DD [1] https://www.sqlite.org/lang_datefunc.html _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users