废话短说
mysql常用函数
select datediff('2023-01-01','2022-09-09');
SELECT rand();
select truncate(rand()*100,0);
select truncate('eeeee',0);
SELECT DATE('2023-02-02 09:09:09');
SELECT TIME ('2023-02-02 09:09:09');
SELECT adddate(now(),1);
SELECT adddate(now(),INTERVAL 1 DAY );
SELECT adddate(now(),INTERVAL 1 MINUTE );
SELECT adddate(now(),INTERVAL 1 YEAR );