1. 日期函数
![在这里插入图片描述](https://img-blog.csdnimg.cn/f5b4df1231ff4949a21b2c813db98dab.png)
select current_date();
select current_time();
select current_timestamp();
select date_add('2017-10-28',interval 10 day);
select date_sub('2017-10-1', interval 2 day);
select datediff('2017-10-10', '2016-9-1');
create table msg(
id int primary key auto_increment,
content varchar(20) no null,
sendtime datetime);
insert into msg(content,sendtime) values ('hello' ,now());
select* from msg;
![在这里插入图片描述](https://img-blog.csdnimg.cn/512a063c448a42988b0e601ea0d245cb.png)
select content,date(sendtime) from msg;
select * from msg where date_add(sendtime, interval 2 minute) > now();
2. 字符串函数
![在这里插入图片描述](https://img-blog.csdnimg.cn/ef0542f0239a41d880219aacce1c8dcb.png)
select charset(ename) from EMP;
select concat(name,'的语文是',chinese,'分,数学是',math,'分') ) as '分数' from student;
select length(name),name from student;
select replace(ename,'s','上海'),ename from emp;
select substring(ename,2,2),ename from emp;
select concat(lcase(substring(ename,1,1)),substring(ename,2)) from emp;
3. 数学函数
![在这里插入图片描述](https://img-blog.csdnimg.cn/d470c8e2bce54ba1ba305dc1eea4a9f2.png)
select abs(-100,2);
select ceiling(23.04);
select floor(23.7);
select format(12.3456,2);
select rand();
4. 其他函数
select user();
select md5('admin');
![在这里插入图片描述](https://img-blog.csdnimg.cn/452bb80acd324cf8953879a72fe323c9.png)
select database();
select password('root');
select ifnull('val1','val2');