View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001752 | SymmetricDS | Improvement | public | 2014-06-08 19:06 | 2014-06-17 00:27 |
| Reporter | wadihkharma | Assigned To | chenson | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.5.22 | ||||
| Target Version | 3.6.0 | Fixed in Version | 3.6.0 | ||
| Summary | 0001752: Date format setting in triggers | ||||
| Description | However i am facing the following problem. All nodes run Oracle databases, most of the client nodes application insert/update data using different Calendar setting (ARABIC HIJRAH). When DATE columns data is added to SYM_DATA.RAW it is converted to the ARABIC HIJRAH format: Example: invoice date 07-JUNE-2014 is inserted as 1435-08-09 instead of 2014-06-07 The solution i found is to adjust the triggers on the tables and force the calendar to GREGORIAN decode((:new."INVDATE",null,'',concat(concat('"',to_char(:new."INVDATE",'YYYY-MM-DD HH24:MI:SS','NLS_CALENDAR=''GREGORIAN''')),'"'))||','|| This works fine but means any change in the triggers i will have to manually readjust it in ALL nodes. Is there a way to have it done by Symmetric when creating the triggers? Thanks Wadih Kharma | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2014-06-08 19:06 | wadihkharma | New Issue | |
| 2014-06-10 11:26 | chenson | Target Version | => 3.6.0 |
| 2014-06-10 11:26 | chenson | Project | SymmetricDS Pro => SymmetricDS |
| 2014-06-10 13:14 | chenson | Status | new => resolved |
| 2014-06-10 13:14 | chenson | Fixed in Version | => 3.6.0 |
| 2014-06-10 13:14 | chenson | Resolution | open => fixed |
| 2014-06-10 13:14 | chenson | Assigned To | => chenson |
| 2014-06-10 14:00 | Changeset attached | => SymmetricDS trunk r8361 | |
| 2014-06-17 00:27 | chenson | Status | resolved => closed |
| 2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master cd46d1a6 |