select to_char(sysdate,'mm') from dual;
出来是03,可是我只想要3
select to_char(sysdate,'m') from dual;报错啊。
就一句sql能不能搞定呢?
------解决思路----------------------
select ltrim(to_char(sysdate,'mm'),'0') from dual;
------解决思路----------------------
select to_number(to_char(sysdate,'mm')) from dual;
------解决思路----------------------
-- 去掉前面的 0
select trim(leading '0' from to_char(sysdate,'mm')) from dual;