search

Home >Database >Mysql Tutorial >求当前时间与当天零点的秒差_MySQL

求当前时间与当天零点的秒差_MySQL

WBOY
WBOYOriginal
2016-06-01 13:31:011296browse

bitsCN.com


求当前时间与当天零点的秒差

 

SELECT MOD(UNIX_TIMESTAMP(NOW())+28800,86400),UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(DATE(NOW()))=====================

 

求当前时间与当天零点的秒差。

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：事务的隔离级别及mysql中相关的设置_MySQLNext article：MySQL Cluster的高可用性

Related articles

See more