[OFBIZ-9337] Update msyql sql-type for datetime field-type to support Fractional Seconds in Time Values

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Done
• Affects Version/s: Trunk
• Fix Version/s: 16.11.05, 17.12.01
• Component/s: ALL APPLICATIONS
• Assignee: Deepak Dixit
• Reporter: Deepak Dixit
• Created: 26/Apr/17 12:25
• Updated: 28/May/18 08:32
• Resolved: 01/May/17 10:35

Description

Mysql 5.6.4 added support to store microseconds in datetime/time field.
Here is the link for discussion on dev list:
https://s.apache.org/ytBk

Need to update fieldtypemysql.xml and update the following field-type

• date-time : use DATETIME (3)
• time : use TIME (3)

Issue Links

• is related to: OFBIZ-3972 user of tenant generate errors on entity Server_Hit
• relates to: OFBIZ-2208 ServerHit aborts transactions when trying to create entries with duplicate startTime(s).
• relates to: OFBIZ-9496 MySql Database related warning related to DATETIME filed
• mentioned in: Page Loading...