I think I would prefer DATETIME. Some reasons are found here -> http://stackoverflow.com/questions/409286/should-i-use-field-datetime-or-timestamp. Given that OFBiz takes care of conversions, DATETIME seems like a more appropriate choice
On Fri, Feb 24, 2017 at 12:13 PM, Jacques Le Roux < [email protected]> wrote: > 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 > >
