如何从 MySQL DATETIME 实例获取总秒数?
mysqlmysqli database更新于 2025/4/6 5:00:17
可以借助 UNIX_TIMESTAMP() 函数将 MySQL DateTime 实例转换为秒，方法如下 −
mysql> Select UNIX_TIMESTAMP('2017-05-15 04:05:30') AS 'NUMBER OF SECONDS';
+-------------------+
| NUMBER OF SECONDS |
+-------------------+
| 1494801330 |
+-------------------+
1 row in set (0.00 sec)
上述查询将给定的日期时间实例转换为总秒数。
mysql> Select UNIX_TIMESTAMP(NOW()) AS 'NUMBER OF SECONDS'; +-------------------+ | NUMBER OF SECONDS | +-------------------+ | 1509248856 | +-------------------+ 1 row in set (0.00 sec)
上述查询将把当前 DateTime 实例转换为总秒数。
mysql> Select UNIX_TIMESTAMP(Dateofreg) AS 'NUMBER OF SECONDS' from testing where StudentName = 'Gaurav'; +-------------------+ | NUMBER OF SECONDS | +-------------------+ | 1509247113 | +-------------------+ 1 row in set (0.00 sec)
上述查询将转换 DateTime 实例，该实例是表 ‘testing’中存储的值，其中 StudentName 列的值为 ‘Gaurav’。
相关文章
有用资源
mysql 参考教程 - 该教程包含有关 mysql 的更多信息:https://www.cainiaomax.com/mysql/
