不同数据库插入时间

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'))