1 select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') as nowTime from dual; //日期转化为字符串
2 select substr(to_char(AUTHORIZE_DATE,'yyyy-mm-dd'),0,4) from s_book 查询年度
1 select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') as nowTime from dual; //日期转化为字符串
2 select substr(to_char(AUTHORIZE_DATE,'yyyy-mm-dd'),0,4) from s_book 查询年度