On 8/24/17, Simon Slavin <slav...@bigfraud.org> wrote: > > Numeric timestamps make it easy to do "24 hours after this timestamp". But > they make it difficult to do "9am the next day".
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'); -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
