SQL> select sysdate from dual;SYSDATE -------------- 12-7月 -08SQL> select to_char(sysdate, 'yyyy'), to_char(sysdate, 'mm'), to_char(sysdate, ' dd') from dual;TO_C TO TO ---- -- -- 2008 07 12SQL>
insert into tableName select to_char(ttime,'yyyy'),to_char(ttime,'MM'),to_char(ttime,'dd') from yourTable;
declare year varchar(6); month varchar(6); day varchar(6); begin select to_char(ttime,'yyyy'),to_char(ttime,'mm'),to_char(ttime,'dd') into year,month,day; end; /
select to_char(sysdate, 'yyyy'), to_char(sysdate, 'mm'), to_char(sysdate, ' dd') from dual;
--------------
12-7月 -08SQL> select to_char(sysdate, 'yyyy'), to_char(sysdate, 'mm'), to_char(sysdate, '
dd') from dual;TO_C TO TO
---- -- --
2008 07 12SQL>
year varchar(6);
month varchar(6);
day varchar(6);
begin
select to_char(ttime,'yyyy'),to_char(ttime,'mm'),to_char(ttime,'dd')
into
year,month,day;
end;
/
dd') from dual;
to_char(sysdate, 'mm'),
to_char(sysdate, 'dd')