1. 获取日期+时间
SELECT SYSDATE() FROM DUAL;
2.获取日期
SELECT CURDATE() FROM DUAL;
3.获取时间
SELECT CURTIME() FROM DUAL;
4.获取unix时间戳
SELECT UNIX_TIMESTAMP() FROM DUAL;
5.unix时间戳转时间
SELECT FROM_UNIXTIME() FROM DUAL;
1. 获取日期+时间
SELECT SYSDATE() FROM DUAL;
2.获取日期
SELECT CURDATE() FROM DUAL;
3.获取时间
SELECT CURTIME() FROM DUAL;
4.获取unix时间戳
SELECT UNIX_TIMESTAMP() FROM DUAL;
5.unix时间戳转时间
SELECT FROM_UNIXTIME() FROM DUAL;