oracle
时间类型为Date,插入时间
INSERT INTO TEST_LOU
(ID,NAME,AGE,BIRTH)
VALUES('${xml.MESSAGE.BODY.ROWS.ROW.ID}',
'${xml.MESSAGE.BODY.ROWS.ROW.NAME}',
'${xml.MESSAGE.BODY.ROWS.ROW.AGE}',
TO_DATE('${xml.MESSAGE.BODY.ROWS.ROW.BIRTH}','yyyy-MM-dd HH24:MI:SS'))
SqlServer
INSERT INTO TEST01
(ID,NAME,AGE,BIRTH)
VALUES('${xml.MESSAGE.BODY.ROWS.ROW.ID}',
'${xml.MESSAGE.BODY.ROWS.ROW.NAME}',
'${xml.MESSAGE.BODY.ROWS.ROW.AGE}',
'${xml.MESSAGE.BODY.ROWS.ROW.BIRTH}',)
MySql
INSERT INTO TEST01
(ID,NAME,AGE,BIRTH)
VALUES('${xml.MESSAGE.BODY.ROWS.ROW.ID}',
'${xml.MESSAGE.BODY.ROWS.ROW.NAME}',
'${xml.MESSAGE.BODY.ROWS.ROW.AGE}',
STR_TO_DATE('${xml.MESSAGE.BODY.ROWS.ROW.BIRTH}','%Y-%m-%d %H:%i:%s'))