You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "Jacopo Cappellato (JIRA)" <ji...@apache.org> on 2018/05/28 08:33:00 UTC

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

    [ 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)