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

[Nicolas Malin (Jira)]

Deepak Dixit created OFBIZ-9337:
-----------------------------------

             Summary: 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://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)






--
This message was sent by Atlassian JIRA
(v6.3.15#6346)