Home >Database >Mysql Tutorial >mysql时间比较的语句_MySQL
mysql时间比较的语句_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:40:371194browse
bitsCN.com
mysql时间比较的语句 假设endTime="2011-01-27 15:52:11", 求出当前时间与结束时间的结果. (以秒为单位.) SELECT TIMESTAMPDIFF(SECOND, now(), '2011-01-27 15:52:11') 语法为： TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)，其中unit单位有如下几种，分别是： FRAC_SECOND (microseconds), SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR。 计算结果为datetime_expr2-datetime_expr1 bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：cannot create windows service for mysql.error:0的问题_MySQLNext article：CentOS下安装Mysql 5.5全过程_MySQL