在前端:TABLE 是表名.,datafield是你的日期的字段名. select to_char(a.datafield,'YYYY-MM-DD') from table a
UPDATE TABLE SET DATE_COL=TRUNC(DATE_COL);
SQL> select sysdate from dual;SYSDATE ------------------- 2004-04-21 09:40:53SQL> alter session set nls_date_format='yyyy-mm-dd';会话已更改。SQL> select sysdate from dual;SYSDATE ---------- 2004-04-21这样能满足你的要求了吗
select to_char(a.datafield,'YYYY-MM-DD') from table a
SET DATE_COL=TRUNC(DATE_COL);
SQL> select sysdate from dual;SYSDATE
-------------------
2004-04-21 09:40:53SQL> alter session set nls_date_format='yyyy-mm-dd';会话已更改。SQL> select sysdate from dual;SYSDATE
----------
2004-04-21这样能满足你的要求了吗