新手请问:tochar和todate是如何使用的?格式?

新手请问:tochar和todate是如何使用的?格式?
---------------------------------------------------------------

SQL> select to_char(sysdate,'yyyymmdd') from dual;

TO_CHAR(SYSDATE,'YYYYMMDD')
---------------------------
20030326

SQL> select to_date('2003-12-12','yyyy-mm-dd') from dual;

TO_DATE('2003-12-12','YYYY-MM-
------------------------------
2003-12-12 00:00:00

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus