MySQL-日期处理

1. 日期格式化取值范围

2. 转化实际操作

2.1 日期转为字符串

SELECT DATE_FORMAT( NOW(), "%Y-%m-%d %H:%i:%s" ) AS date FROM DUAL;

运行结果：2022-06-23 13:24:17

2.2 日期转为时间戳

SELECT UNIX_TIMESTAMP(NOW()) AS date FROM DUAL;

运行结果：1655961979，单位：s

2.3 字符串转为日期

SELECT STR_TO_DATE("2022-06-23 13:28:30","%Y-%m-%d %H:%i:%s") AS date FROM DUAL;

运行结果：2022-06-23 13:28:30

2.4 时间戳转日期

SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())) AS date FROM DUAL;

运行结果：2022-06-23 13:29:26

2.5 时间戳转字符串

SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()), "%Y-%m-%d %H:%i:%s") AS date FROM DUAL;

运行结果：2022-06-23 13:30:42

其他参考：MYSQL时间函数 - 简书