View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001456 | SymmetricDS | Bug | public | 2013-10-28 17:19 | 2019-04-22 14:15 |
Reporter | szambaux | Assigned To | |||
Priority | normal | ||||
Status | new | Resolution | open | ||
Product Version | 3.5.10 | ||||
Summary | 0001456: DbImport date problem Oracle 11G | ||||
Description | send 0000-00-00 00:00:00 in XML get 30/11/0003 00:00:00,000000000 in Oracle database | ||||
Steps To Reproduce | Try to execute: /opt/symmetric/bin/dbimport --format XML --drop-if-exists -p /opt/symmetric/conf/symmetric.properties /liveUpdate/CLIENT.xml CLIENT.xml: structure: <?xml version="1.0" encoding="UTF-8"?><database name="eseason"><table name="CLIENT"> <column name="CLADHESFID" type="TIMESTAMP" size="0" required="false"/> <column name="CLVALIDFID" type="TIMESTAMP" size="0" required="false"/> ... <field name="CLADHESFID">0000-00-00 00:00:00</field> <field name="CLVALIDFID">0000-00-00 00:00:00</field> ... | ||||
Tags | data conversion, dbimport/dbexport | ||||