SQL语句求教

Question

select substr(TIME,-2) from ....;
or
select substr(TIME,5,2) from ....;mod:求余
16:52:34 jlanzpa817>select mod(5,3) from dual;  MOD(5,3)
----------
         2已用时间:  00: 00: 00.10

Answer 1

SQL> select to_number(to_char(to_date('200301','yyyy-mm'),'mm')) from dual;TO_NUMBER(TO_CHAR(TO_DATE('200
------------------------------
                             1
SQL> select mod(10,3) from dual; MOD(10,3)
----------
         1

Answer 2

select to_number(to_char(TIME,'mm')) from tablename
MOD(10,4)=2
MOD(10,5)=0

Answer 3

select to_number(to_char(to_date(TIME,'yyyy-mm'),'mm')) from tablename
MOD(10,4)=2
MOD(10,5)=0