MySQL 数据类型转换

select convert(‘100‘,signed) column_convert; 2 select cast(‘100‘ as signed) column_cast;

二.下面介绍下时间转换

1 select convert(now(),date) convert_date;
2 select convert(now(),time) convert_time;
3 select convert(now(),datetime) convert_datetime;
4 select convert(now(),char(10)) convert_char10;
5 select convert(now(),char(19)) convert_char19;

 

MySQL 数据类型转换

标签：var   class   整数   har   语法   sign   时间   binary   pre