Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0041476Openbravo ERPA. Platformpublic2019-07-29 17:032019-08-19 09:45
AugustoMauch 
alostale 
normalmajorhave not tried
closedinvalid 
5
 
 
Core
No
0041476: API Change: Columns that use the Date reference will only store date part (and not time part) in the database
The current behaviour of columns that use the Date reference is the following:
- When saving a record from the ERP, the incoming date value has the YYYY-MM-DD format, and the data is stored with 00:00:00 as the time part.
- When the value is programatically set (i.e. order.setOrderDate(new Date()) ), then both the date and the time part of the given date will be stored in the database.

The proposed change is to automatically strip the time part for values used in columns that use the Date reference.

Impact: Only those flows that were programatically setting dates with a time part, and then retrieving the store date and using the time part would be affected.

Those affected should use the DateTime reference instead.
-
No tags attached.
related to design defect 0040905 new AugustoMauch It would be fine to automatically truncate the value if the reference is date 
Issue History
2019-07-29 17:03AugustoMauchNew Issue
2019-07-29 17:03AugustoMauchAssigned To => alostale
2019-07-29 17:03AugustoMauchModules => Core
2019-07-29 17:03AugustoMauchTriggers an Emergency Pack => No
2019-07-29 17:03AugustoMauchRelationship addedrelated to 0040905
2019-07-29 17:05AugustoMauchDescription Updatedbug_revision_view_page.php?rev_id=19210#r19210
2019-08-19 09:45AugustoMauchNote Added: 0114063
2019-08-19 09:45AugustoMauchStatusnew => closed
2019-08-19 09:45AugustoMauchResolutionopen => invalid

Notes
(0114063)
AugustoMauch   
2019-08-19 09:45   
The issue this API change was related with has been moved to design defect, will not be done in the near future