Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0002448 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] Z. Others | minor | always | 2008-01-02 15:03 | 2008-06-12 09:43 | |||
Reporter | gorkaion | View Status | public | |||||
Assigned To | gorkaion | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | 2.40alpha-r2 | |||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | No | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0002448: Problem with default dates format | |||||||
Description | In several database objects are used different dates as a minimum or maximum dates without any mask. If the NLS_DATE_FORMAT defined in the database is different that the used in the object the application throws a Month not valid exception. See M_INOUT_CHK_RESTRICTIONS_TRG trigger as an example. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
|
![]() |
|
(0002913) gorkaion (viewer) 2008-01-02 18:29 edited on: 2008-06-12 09:23 |
Logged In: YES user_id=1500690 Originator: YES Fixed all default dates to include a to_date function with the correspondent mask. The default limit dates for comparisons have been set to January 1, 1900 and December 31, 9999. |
(0002914) psarobe (viewer) 2008-06-04 17:03 edited on: 2008-06-12 09:23 |
Logged In: YES user_id=1500703 Originator: NO Tested making a random in some objects (procedures, functions, triggers) |
(0006037) user71 2005-06-01 00:00 edited on: 2008-06-12 09:43 |
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1862189 [^] |
Copyright © 2000 - 2009 MantisBT Group |