rendered paste bodymysql> select from_unixtime(loginTime),from_unixtime(logoutTime),agentOnline from agents;
+--------------------------+---------------------------+-------------+
| from_unixtime(loginTime) | from_unixtime(logoutTime) | agentOnline |
+--------------------------+---------------------------+-------------+
| 2008-05-01 19:54:08 | 1969-12-31 16:00:00 | 1 |
| 2008-05-01 22:22:45 | 2008-05-01 22:33:01 | 0 |
| 2008-05-01 18:14:13 | 1969-12-31 16:00:00 | 1 |
| 2008-05-01 17:30:27 | 2008-05-01 18:00:48 | 0 |
| 2008-05-02 03:02:06 | 2008-05-02 03:10:44 | 0 |
| 2008-05-02 04:32:32 | 2008-05-02 05:10:39 | 0 |
| 2008-05-02 06:37:22 | 1969-12-31 16:00:00 | 0 |
| 2008-05-01 21:37:48 | 1969-12-31 16:00:00 | 1 |
| 2008-05-02 06:23:50 | 1969-12-31 16:00:00 | 1 |
| 2008-05-01 16:46:07 | 1969-12-31 16:00:00 | 1 |
| 2008-05-02 05:16:50 | 2008-05-02 05:27:42 | 0 |
| 2008-05-02 00:36:27 | 2008-05-02 00:40:16 | 0 |
| 2008-05-02 04:59:54 | 2008-05-02 05:27:01 | 0 |
| 2008-05-01 22:16:10 | 2008-05-01 22:16:45 | 0 |
| 2008-05-02 00:21:59 | 2008-05-02 00:23:11 | 0 |
| 2008-05-02 05:12:05 | 2008-05-02 05:27:30 | 0 |
| 2008-05-01 22:33:13 | 1969-12-31 16:00:00 | 1 |
| 2008-05-02 02:19:55 | 2008-05-02 02:21:24 | 0 |
| 2008-05-02 01:03:41 | 2008-05-02 01:07:12 | 0 |
| 2008-05-02 06:23:41 | 1969-12-31 16:00:00 | 1 |
| 2008-05-02 06:37:09 | 1969-12-31 16:00:00 | 0 |
| 2008-05-01 16:35:42 | 1969-12-31 16:00:00 | 1 |
| 2008-05-02 05:43:41 | 1969-12-31 16:00:00 | 1 |
| 2008-05-01 17:04:56 | 1969-12-31 16:00:00 | 0 |
| 2008-05-01 20:52:22 | 1969-12-31 16:00:00 | 1 |
| 2008-05-02 05:28:59 | 1969-12-31 16:00:00 | 1 |
+--------------------------+---------------------------+-------------+