Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sqlite> select datetime(utcsec, 'unixepoch') from logs where datetime(utcsec, 'unixepoch') BETWEEN datetime('now') AND datetime('now', '-20 minutes') LIMIT 10;
- sqlite> select datetime(utcsec, 'unixepoch') from logs LIMIT 1;
- 2015-05-28 15:20:19
- sqlite> select datetime('now');
- 2015-05-28 20:03:29
- sqlite> select datetime('now', '-20 minutes');
- 2015-05-28 19:43:41
- sqlite>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement