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

["Deepak Dixit (JIRA)" <ji...@apache.org>]

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

Deepak Dixit commented on OFBIZ-9337:
-------------------------------------

This has been done at r#1793300

Added generateMySqlFileWithAlterTableForTimestamps service to generate sql alter statement for date-time and time filed. 
groupName is required field for this service ,it will generate sql file at location ofbiz.home/runtime/tempfiles/<groupName>.sql 

User can use [mysql batch command|https://dev.mysql.com/doc/refman/5.6/en/mysql-batch-commands.html] to execute sql statement from text file.

Also update the [Data Migration|https://cwiki.apache.org/confluence/x/LoBr] wiki page with revision and migration service detail.


> 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
>
> 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
(v6.3.15#6346)