ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepak Dixit (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (OFBIZ-9337) Update msyql sql-type for datetime field-type to support Fractional Seconds in Time Values
Date Mon, 01 May 2017 10:25:04 GMT

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

Deepak Dixit edited comment on OFBIZ-9337 at 5/1/17 10:24 AM:
--------------------------------------------------------------

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 [Data Migration|https://cwiki.apache.org/confluence/x/LoBr] wiki page with revision
and migration service detail.



was (Author: deepak.dixit):
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)

Mime
View raw message