Advertisement
Guest User

Untitled

a guest
May 28th, 2015
239
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. sqlite> select datetime(utcsec, 'unixepoch') from logs where datetime(utcsec, 'unixepoch') BETWEEN datetime('now') AND datetime('now', '-20 minutes') LIMIT 10;
  2. sqlite> select datetime(utcsec, 'unixepoch') from logs LIMIT 1;
  3. 2015-05-28 15:20:19
  4. sqlite> select datetime('now');
  5. 2015-05-28 20:03:29
  6. sqlite> select datetime('now', '-20 minutes');
  7. 2015-05-28 19:43:41
  8. sqlite>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement