摘要: select to_char(sysdate, 'yyyy') from dual;select to_char(sysdate, 'mm') from dual;select to_char(sysdate, 'dd') from dual; 阅读全文
posted @ 2012-02-03 11:08 小波Ooo 阅读(126) 评论(0) 推荐(0) 编辑
摘要: select round(34.44,0) from dual结果:34select round(34.76,0) from dual结果:35select mod(103,10) from dual结果:3 阅读全文
posted @ 2012-02-03 11:05 小波Ooo 阅读(421) 评论(0) 推荐(0) 编辑