Re: OFBIZ-3972

2017-05-01 Thread Deepak Dixit
t;>>> 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 >&

Re: OFBIZ-3972

2017-04-26 Thread Deepak Dixit
;> http://www.hotwaxsystems.com >>> >>> On Fri, Feb 24, 2017 at 3:37 PM, Taher Alkhateeb < >>> slidingfilame...@gmail.com >>> >>>> wrote: >>>> I think I would prefer DATETIME. Some reasons are found here -> >>>> http://stackover

Re: OFBIZ-3972

2017-03-15 Thread Jacques Le Roux
TIME seems like a more appropriate choice On Fri, Feb 24, 2017 at 12:13 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: Hi, At OFBIZ-3972 Deepak suggested <> I suggested <https://dev.mysql.com/doc/ refman/5.6/en/datetime.html Deepak rightly mentioned that in both cases

Re: OFBIZ-3972

2017-03-14 Thread Deepak Dixit
conversions, DATETIME seems like a more > > appropriate choice > > > > On Fri, Feb 24, 2017 at 12:13 PM, Jacques Le Roux < > > jacques.le.r...@les7arts.com> wrote: > > > > > Hi, > > > > > > At OFBIZ-3972 Deepak suggested > >

Re: OFBIZ-3972

2017-02-28 Thread Rishi Solanki
DATETIME seems like a more > appropriate choice > > On Fri, Feb 24, 2017 at 12:13 PM, Jacques Le Roux < > jacques.le.r...@les7arts.com> wrote: > > > Hi, > > > > At OFBIZ-3972 Deepak suggested > > > > < > As we have only DATETIME set as sql typ

Re: OFBIZ-3972

2017-02-24 Thread Taher Alkhateeb
oux < jacques.le.r...@les7arts.com> wrote: > Hi, > > At OFBIZ-3972 Deepak suggested > > < 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 > > <https://dev.mysql.

OFBIZ-3972

2017-02-24 Thread Jacques Le Roux
Hi, At OFBIZ-3972 Deepak suggested <> I suggested <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

[jira] [Closed] (OFBIZ-3972) user of tenant generate errors on entity Server_Hit

2013-02-09 Thread Jacques Le Roux (JIRA)
[ https://issues.apache.org/jira/browse/OFBIZ-3972?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux closed OFBIZ-3972. -- Resolution: Duplicate Assignee: Jacques Le Roux Since 5.6 is officially released

[jira] [Commented] (OFBIZ-3972) user of tenant generate errors on entity Server_Hit

2013-01-10 Thread Paul Piper (JIRA)
[ https://issues.apache.org/jira/browse/OFBIZ-3972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13549584#comment-13549584 ] Paul Piper commented on OFBIZ-3972: --- If your database is MySQL then I second Jacques

[jira] Commented: (OFBIZ-3972) user of tenant generate errors on entity Server_Hit

2011-01-23 Thread Jacques Le Roux (JIRA)
[ https://issues.apache.org/jira/browse/OFBIZ-3972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12985276#action_12985276 ] Jacques Le Roux commented on OFBIZ-3972: Pierre, Was this with mySql? Because

[jira] Created: (OFBIZ-3972) user of tenant generate errors on entity Server_Hit

2010-10-01 Thread Pierre Smits (JIRA)
user of tenant generate errors on entity Server_Hit --- Key: OFBIZ-3972 URL: https://issues.apache.org/jira/browse/OFBIZ-3972 Project: OFBiz Issue Type: Bug Components: framework