[jira] [Commented] (OFBIZ-9337) Update msyql sql-type for datetime field-type

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-9337) Update msyql sql-type for datetime field-type

Nicolas Malin (Jira)

    [ https://issues.apache.org/jira/browse/OFBIZ-9337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15984956#comment-15984956 ]

Jacques Le Roux commented on OFBIZ-9337:
----------------------------------------

bq. Deepak rightly mentioned that [...] we need to create an entry in "data migration" wiki page

> Update msyql sql-type for datetime field-type
> ---------------------------------------------
>
>                 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
>
> Mysql 5.6 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
(v6.3.15#6346)