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 |