Insert into D_SA001000
(DAY_HHMMSS,
CENTER,
DEPARTMENT,
STATION,
TYPE,
NUM,
CODE,
PATH,
PARATYPE,
REGID)
--'yyyymmddHH24MISS'注意精度,根据表的时间字段设置
select TO_TIMESTAMP(DAY_HHMMSS,'yyyymmddHH24MISS') DAY_HHMMSS2,
CENTER,
DEPARTMENT,
STATION,
TYPE,
NUM,
CODE,
PATH,
PARATYPE,
REGID
from SEDB_TAB3001
(DAY_HHMMSS,
CENTER,
DEPARTMENT,
STATION,
TYPE,
NUM,
CODE,
PATH,
PARATYPE,
REGID)
--'yyyymmddHH24MISS'注意精度,根据表的时间字段设置
select TO_TIMESTAMP(DAY_HHMMSS,'yyyymmddHH24MISS') DAY_HHMMSS2,
CENTER,
DEPARTMENT,
STATION,
TYPE,
NUM,
CODE,
PATH,
PARATYPE,
REGID
from SEDB_TAB3001