THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
ALTER TABLE CUSTOM_TIME_PERIOD MODIFY COLUMN FROM_DATE datetime, MODIFY COLUMN THRU_DATE datetime;
R "Update msyql sql-type for datetime field-type to support Fractional Seconds in Time Values"
| Jira | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Updated sql-type for date-time and time field in fieldtypemysql.xml file,
| OFBiz type | old mySql data-type | new mysql data-type |
|---|---|---|
| date-time | DATETIME | DATETIME(3) |
| time | TIME | TIME(3) |
Please upgrade mysql to at least 5.6.4 or higher.
After upgrade run the 'generateMySqlFileWithAlterTableForTimestamps' service, groupName is required field for this service,
It will generate the sql file with alter query statement for date-time and time field under "${ofbiz.home}/runtime/tempfiles/<groupName>.sql"
You can use execute sql statement from any of the mysql batch command.