[ https://issues.apache.org/jira/browse/OFBIZ-9337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16492405#comment-16492405 ]
Jacopo Cappellato commented on OFBIZ-9337: ------------------------------------------ Backported to 16.11 with revision 1832367 in order to fix OFBIZ-10321 > Update msyql sql-type for datetime field-type to support Fractional Seconds > in Time Values > ------------------------------------------------------------------------------------------ > > Key: OFBIZ-9337 > URL: https://issues.apache.org/jira/browse/OFBIZ-9337 > Project: OFBiz > Issue Type: Improvement > Components: ALL APPLICATIONS > Affects Versions: Trunk > Reporter: Deepak Dixit > Assignee: Deepak Dixit > Priority: Major > Fix For: 17.12.01, 16.11.05 > > > 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) -- This message was sent by Atlassian JIRA (v7.6.3#76005)