在oracle中建有date类型的字段,插入可以采取如下方法:
如果是小时为:1-12 采取如下格式:yyyy-mm-dd HH:MI:SS
insert into test values(to_date('2009-5-7 07:09:37','yyyy-mm-dd HH:MI:SS'));
如果是小时为:1-24 采取如下格式:yyyy-mm-dd HH24:MI:SS
insert into test values(to_date('2009-5-7 17:09:37','yyyy-mm-dd HH24:MI:SS'));
oracle中导入数据:
首先,建表:
create table ACAA02_AFC_SYSTEM_BODY(
AFC_ID
DEAL_TYPE
SAM_CODE
DEAL_SEQ_NUM
DEAL_TIME
CITY_CODE
BUSINESS_CODE
GRANT_CARD_CODE
CARD_TYPE
PACKAGE_RECORD_NUM
DEAL_STATUS NUMBER(4,0),
TICKET_TYPE NUMBER(4,0),
ENTRY_LINE_NUM
ENTRY_STATION_NUM
ENTRY_TIME DATE,
EXIT_LINE_NUM
EXIT_STATION_NUM NUMBER(4,0),
CONTINUED_ENTERPRISE
SOURCE_PARTICIPANT_ID NUMBER(10,0),
DEVICE_ID
DEVICE_LOCATION
RECONCILIATION_DATE
DES_PARTICIPANT_ID
CURRENT_LOCATION NUMBER(10,0),
TRIP_ORIGIN_LOCATION
TRIP_PRE_LOCATION
TOTAL_AMOUNT
VALIDATE_DATE
ENTRY_CONTINUED_TIME
VALUE_PER_RIDE
END_OF_JOURENY
DELAY_DATE NUMBER(10,0),
DELAY_STATION_LOCATION NUMBER(10,0),
DELAY_OPERATION_MODE
VAL_FLAG
CREATEDATE DATE,
UPDATEDATE DATE,
LOW_COMP_CODE
BUS_GROUP_CODE
GET_POINT_CODE
POS_CODE
BL_COMP_CODE
);
其次,在该表右键,导入数据,对于不匹配的格式,进行一些处理,如date格式为2013/6/1 9:45:36,则应写成yyyy/mm/dd HH24:MI:SS格式。