1 概述
2 类型转换
![在这里插入图片描述](https://img-blog.csdnimg.cn/7a52d728bb864c2a93db191d2ee99a4e.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6bG85Li45Li257KX6Z2i,size_15,color_FFFFFF,t_70,g_se,x_16)
select
convert(2022, char(3)) c1,
convert(2022, char(4)) c2,
convert(2022, char(5)) c3,
convert('-12.56', SIGNED) s1,
convert('12.56', UNSIGNED) u1,
convert('12.56', decimal(3, 1)) dc1,
convert('2021-05-20 13:14:00', datetime) d1,
convert('2021-05-20 13:14:00', date) d2,
convert('2021-05-20 13:14:00', time) d3,
str_to_date('2021-05-20 13:14:00', '%Y-%m-%d %H:%i:%S') d4,
str_to_date(now(), '%Y-%m-%d') d5,
convert(now(), char) c4,
date_format(now(), '%Y-%m-%d %H:%i:%S') c5
from dual;
3 扩展
3.1 日期时间函数