On 25 Aug 2017, at 2:10am, Richard Hipp <[email protected]> wrote: > See the "Modifiers" section of https://sqlite.org/lang_datefunc.html > > To get the date-and-time for "9am the next day" given a numeric > timestamp as a julian day number: > > SELECT datetime(numericJDTime, 'start of day', '+33 hours'); > > If you timestamp is unix (seconds since 1970): > > SELECT datetime(numericUnixTime, 'unixepoch', 'start of day', '+33 > hours');
Impressive and useful. Simon _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
