Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0003411Openbravo ERPA. Platformpublic2007-10-31 12:052009-05-22 19:34
Reportercromero 
Assigned Toiciordia 
PrioritynormalSeverityminorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0003411: Different behavior for dates Oracle/Postgre
DescriptionOracle 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
Steps To Reproduce
Proposed Solution
Additional Information
TagsReleaseCandidate, Usability
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-11-10 13:11cromeroAssigned Tocromero => pjuvara
2008-11-16 08:48pjuvaraStatusnew => acknowledged
2008-11-16 08:48pjuvaraTag Attached: ReleaseCandidate
2008-11-16 08:48pjuvaraTag Attached: Usability
2008-11-16 08:49pjuvaraCategoryF. Localization => A. Platform (WAD, XmlEngine, SQLC)
2008-11-16 08:49pjuvaraDescription Updated
2009-05-22 19:34pjuvaraAssigned Topjuvara => iciordia

Notes
(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 [^]
(0003920)
cromero   
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.