SELECTROUND(10/3,2)FROMdual;
selectCEIL(9.1)fromdual;
SELECTFLOOR(9.1)fromdual;
selectROUND(10/3,2)fromdual;
selectCEILING(2.3)fromdual;
selectFLOOR(2.1)FROMdual
select*
fromw_bas_sku
whereidregexp'[^0-9]';
select*fromw_bas_userwhereuser_nameREGEXP'^[0-9]';
selectdate_format('11/9/20','%Y/%m/%d');
selectdate_format('11-9-20','%d-%Y-%M');
SELECTDATE_FORMAT('11-9-20','%D-%Y-%m');
SELECTDATE_FORMAT('11-9-20','%Y/%m/%d');
selecttrunc(now())
selectstr_to_date('11-9-20','%m-%d-%Y');
selectstr_to_date('11-9-20','%c-%d-%y');
%Y:年
%c:月
%d:日
%H:小时
%i:分钟
%s:秒
mysql>selectdate_format(now(),'%Y-%c-%d %h:%i:%s');
+|date_format(now(),'%Y-%c-%d %h:%i:%s')|