Zeitdifferenz
| ID | 172 |
|---|---|
| Link Reference | Not set |
| Link Credits | Not set |
| Link Technical Documentation | https://www.sqlite.org/lang_datefunc.html |
| PlCodelang | SQLite |
| PlGroup | Datum, Zeit |
| PlItemTitle | Zeitdifferenz |
| Code | -- http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions SELECT (strftime('%s','now') - strftime('%s',date('now','-1 day'))) AS Seconds -- https://stackoverflow.com/questions/289680/difference-between-2-dates-in-sqlite SELECT CAST(JulianDay('now') - JulianDay(MAX(datetime_field_in_table)) * 24 * 60 AS Integer) AS diff_minutes FROM example_table |
| Result Example |