select to_char(to_date('2003.04.01', 'yyyy.mm.dd'), 'yyyy-mm-dd') from dual
什么叫“要是要传给另一个表的另一个字段呢?” select to_char(to_date(aa,'yyyy.mm'),'yyyy-mm')||'-01' from table
other_tab中的your_date字段是char型的: insert into other_tab(your_date) values(select to_char(to_date('2003.04.01', 'yyyy.mm.dd'), 'yyyy-mm-dd') from dual); other_tab中的your_date字段是date型的: insert into other_tab(your_date) values(select to_date('2003.04.01', 'yyyy.mm.dd') from dual);
select to_char(trunc(sysdate,'mm'),'yyyy-mm-dd') from dual;
select to_char(trunc(to_date(charcol,'yyyy-mm-dd'),'mm'),'yyyy-mm-dd') from dual;
select to_char(to_date(aa,'yyyy.mm'),'yyyy-mm')||'-01' from table
insert into other_tab(your_date) values(select to_char(to_date('2003.04.01', 'yyyy.mm.dd'), 'yyyy-mm-dd') from dual);
other_tab中的your_date字段是date型的:
insert into other_tab(your_date) values(select to_date('2003.04.01', 'yyyy.mm.dd') from dual);
from dual;