1. Overview SQLite supports seven scalar date and time functions as follows: date(time-value, modifier, modifier, ...) time(time-value, modifier, modifier, ...) datetime(time-value, modifier, modifier, ...) julianday(time-value, modifier, modifier, ...) unixepoch(time-value, modifier, modifier, ...) strftime(format, time-value, modifier, modifier, ...) timediff(time-value, time-value) The first si