View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001456 | SymmetricDS | Bug | public | 2013-10-28 17:19 | 2024-11-06 19:09 |
| Reporter | szambaux | Assigned To | |||
| Priority | normal | ||||
| Status | closed | Resolution | won't fix | ||
| 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 | ||||
|
|
Is that even a valid datetime in Oracle? What value should the result be? |
|
|
it's not a valid datetime for Oracle, but maybe it could be better to set null instead of 30/11/0003 00:00:00,000000000 |
|
|
You can add the zeroDateTimeBehavior=convertToNull parameter to the MySQL db.url so that these zero dates will export as null values. |
|
|
More details on MySQL dates https://www.jumpmind.com/blog/blog/dialects/filtering-dates-in-mysql/ |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-10-28 17:19 | szambaux | New Issue | |
| 2013-10-28 22:26 | chenson | Note Added: 0000381 | |
| 2013-10-30 16:51 | szambaux | Note Added: 0000383 | |
| 2019-04-22 14:15 | elong | Tag Attached: data conversion | |
| 2019-04-22 14:15 | elong | Tag Attached: dbimport/dbexport | |
| 2024-11-06 19:08 | emiller | Status | new => closed |
| 2024-11-06 19:08 | emiller | Resolution | open => won't fix |
| 2024-11-06 19:08 | emiller | Note Added: 0002522 | |
| 2024-11-06 19:09 | josh-a-hicks | Note Added: 0002523 |