转换为时间戳

函数：UNIX_TIMESTAMP()

举例：

select UNIX_TIMESTAMP('2022-07-18 14:19:00');

查询结果：

1658125140

参考：https://www.it1352.com/1662900.html

获取日期、小时、分

select date(now()), day(now()), hour(now()), minute(now());

结果

+-------------+------------+-------------+---------------+
| date(now()) | day(now()) | hour(now()) | minute(now()) |
+-------------+------------+-------------+---------------+
| 2022-07-20  |         20 |          21 |            35 |
+-------------+------------+-------------+---------------+