Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0003411 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| feature request | [Openbravo ERP] A. Platform | minor | always | 2007-10-31 12:05 | 2009-05-22 19:34 | ||||||
| Reporter | cromero | View Status | public | ||||||||
| Assigned To | iciordia | ||||||||||
| Priority | normal | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | 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 | ||||||||||
| Review Assigned To | |||||||||||
| Web browser | |||||||||||
| Modules | Core | ||||||||||
| Regression level | |||||||||||
| Regression date | |||||||||||
| Regression introduced in release | |||||||||||
| Regression introduced by commit | |||||||||||
| Triggers an Emergency Pack | No | ||||||||||
| Summary | 0003411: Different behavior for dates Oracle/Postgre | ||||||||||
| Description | Oracle admits dates inserted in (dd-mm-yyyy) or (dd-mm-yy), making an automatic cast of the 2-digit year to 4 digits. Postgres works fine with dates specified in valid format (dd-mm-yyyy), but it doesn't auto-cast dates of 2-Digits format to 4-Digits. Both versions should have the same behavior. Carlos Romero Openbravo Team | ||||||||||
| Tags | ReleaseCandidate, Usability | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0003920) cromero (reporter) 2008-04-24 13:14 edited on: 2008-06-12 09:26 |
Logged In: YES user_id=1500614 Originator: YES The problem is that when you insert a date with 2 digits, in Oracle it is casted to dates above 2000 while PostgreSQL inserts 00 above so if you insert '01-01-01', in Oracle it will be inserted as 01-01-2001 and in PostgreSQL will be 01-01-0001. |
|
(0007000) user71 2005-06-01 00:00 edited on: 2008-06-12 09:44 |
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=1823407 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-11-10 13:11 | cromero | Assigned To | cromero => pjuvara |
| 2008-11-16 08:48 | pjuvara | Status | new => acknowledged |
| 2008-11-16 08:48 | pjuvara | Tag Attached: ReleaseCandidate | |
| 2008-11-16 08:48 | pjuvara | Tag Attached: Usability | |
| 2008-11-16 08:49 | pjuvara | Category | F. Localization => A. Platform (WAD, XmlEngine, SQLC) |
| 2008-11-16 08:49 | pjuvara | Description Updated | |
| 2009-05-22 19:34 | pjuvara | Assigned To | pjuvara => iciordia |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |