Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformminoralways2007-10-31 12:052009-05-22 19:34
ReportercromeroView Statuspublic 
Assigned Toiciordia 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0003411: 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
TagsReleaseCandidate, Usability
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
cromero (reporter)
2008-04-24 13:14
edited on: 2008-06-12 09:26

Logged In: YES
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.
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: [^]

- 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker