1 概述
2 类型转换
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;