beowulf1416

Untitled

Aug 26th, 2015
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. mysql> select
  2. -> unix_timestamp(),
  3. -> unix_timestamp(ts),
  4. -> round(unix_timestamp(ts)),
  5. -> max(unix_timestamp() - round(unix_timestamp(ts)))
  6. -> from heartbeat
  7. -> where server_id = 3;
  8. +------------------+--------------------+---------------------------+---------------------------------------------------+
  9. | unix_timestamp() | unix_timestamp(ts) | round(unix_timestamp(ts)) | max(unix_timestamp() - round(unix_timestamp(ts))) |
  10. +------------------+--------------------+---------------------------+---------------------------------------------------+
  11. | 1440604167 | 1440604168 | 1440604168 | -1 |
  12. +------------------+--------------------+---------------------------+---------------------------------------------------+
  13. 1 row in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment