mysq 日期相减

来源：互联网发布：园林设计效果图软件编辑：程序博客网时间：2024/05/16 09:42
mysql> desc test200;+---------------+----------+------+-----+---------+-------+| Field         | Type     | Null | Key | Default | Extra |+---------------+----------+------+-----+---------+-------+| id            | int(11)  | YES  |     | NULL    |       || registerTime  | datetime | YES  |     | NULL    |       || lastLoginTime | datetime | YES  |     | NULL    |       |+---------------+----------+------+-----+---------+-------+3 rows in set (0.00 sec)mysql> select * from test200;+------+---------------------+---------------------+| id   | registerTime        | lastLoginTime       |+------+---------------------+---------------------+|    1 | 2016-10-21 09:06:23 | 2016-10-21 09:06:56 ||    1 | 2016-10-21 09:16:11 | 2016-10-21 09:16:11 |+------+---------------------+---------------------+2 rows in set (0.00 sec)mysql> select lastLoginTime - registerTime from test200;+------------------------------+| lastLoginTime - registerTime |+------------------------------+|                           33 ||                            0 |+------------------------------+2 rows in set (0.00 sec)mysql> select (UNIX_TIMESTAMP(lastLoginTime) - UNIX_TIMESTAMP(registerTime)) from test200;+----------------------------------------------------------------+| (UNIX_TIMESTAMP(lastLoginTime) - UNIX_TIMESTAMP(registerTime)) |+----------------------------------------------------------------+|                                                             33 ||                                                              0 |+----------------------------------------------------------------+2 rows in set (0.00 sec)mysql> select now(),lastLoginTime,(UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(lastLoginTime)) from test200;+---------------------+---------------------+---------------------------------------------------------+| now()               | lastLoginTime       | (UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(lastLoginTime)) |+---------------------+---------------------+---------------------------------------------------------+| 2016-10-21 09:32:32 | 2016-10-21 09:06:56 |                                                    1536 || 2016-10-21 09:32:32 | 2016-10-21 09:16:11 |                                                     981 |+---------------------+---------------------+---------------------------------------------------------+2 rows in set (0.01 sec)
0 0