Hi, At OFBIZ-3972 Deepak suggested
<<I think we need to update fieldtypemysql.xml to honor Milliseconds. As we have only DATETIME set as sql type and this does not support Milliseconds, we need to use DATETIME(3) or DATETIME(6).>> I suggested <<Why not TIMESTAMP? https://dev.mysql.com/doc/refman/5.6/en/datetime.html>> Deepak rightly mentioned that in both cases we need to create an entry in "data migration" wiki page << we need to run alter query manually (if someone want to upgrade custom solution to latest)>> Please let know your thoughts and suggestions if any Jacques
