[jira] [Updated] (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:all-tabpanel ]

Deepak Dixit updated OFBIZ-9337:
--------------------------------
    Description:
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)




  was:
Mysql 5.6 added support to store microseconds in datetime/time field.
Here is the link for discussion on dev list:
https://lists.apache.org/thread.html/32d9249d58c00bae20264c96b6de0288eb6a36b5e97d60332ad5ad49@%3Cdev.ofbiz.apache.org%3E


Need to update fieldtypemysql.xml and update the following field-type
- date-time : use DATETIME (3)
- time : use TIME (3)

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