calculatetimes
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| calculatetimes [2021/02/16 13:54] – wikiadmin | calculatetimes [2021/02/16 13:55] (current) – wikiadmin | ||
|---|---|---|---|
| Line 38: | Line 38: | ||
| </ | </ | ||
| + | Last 24 hours: | ||
| + | <code sql> | ||
| SELECT x.*, time(Cast (( JulianDay(y.dt) - JulianDay(x.dt)) * 24 * 60 * 60 As Integer), ' | SELECT x.*, time(Cast (( JulianDay(y.dt) - JulianDay(x.dt)) * 24 * 60 * 60 As Integer), ' | ||
| FROM my_table AS x | FROM my_table AS x | ||
| Line 46: | Line 48: | ||
| | | ||
| BY x.id; | BY x.id; | ||
| + | </ | ||
| A similar problem (with solution) is described here: | A similar problem (with solution) is described here: | ||
| https:// | https:// | ||
calculatetimes.1613501673.txt.gz · Last modified: by wikiadmin