Mailing-List: contact dev-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@ofbiz.apache.org
Subject: Re: OFBIZ-3972
To: dev@ofbiz.apache.org
References: <5a197ff3-9303-b8ab-dd4a-2a3b176941cc@les7arts.com>
	<CAFqjAi3HQxPTccrpGhjQeSwdzB0Uk8P_TnZ96wkHq4iUxbXThw@mail.gmail.com>
	<CAM2w_=D2F+WxU=ZYHHoch+Cn5qVT8X+mZ9+b=SqUMVvJTFwbbw@mail.gmail.com>
	<CANE8kk8_hCE8jEfgC8mRigwmM-9uR-nbu8jfT1=FtcAmPxHWJg@mail.gmail.com>
From: Jacques Le Roux <jacques.le.roux@les7arts.com>
Organization: Les Arts Informatiques
Message-ID: <215b1444-9e65-cab1-caaf-fe2d7d30f20b@les7arts.com>
Date: Wed, 15 Mar 2017 07:06:26 +0100
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101
	Thunderbird/45.8.0
MIME-Version: 1.0
In-Reply-To: 
	<CANE8kk8_hCE8jEfgC8mRigwmM-9uR-nbu8jfT1=FtcAmPxHWJg@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
archived-at: Wed, 15 Mar 2017 06:06:18 -0000

It's OK with me, I was just asking a question and it seems it has been answered

Jacques


Le 15/03/2017 à 05:10, Deepak Dixit a écrit :
> Can we conclude this?
>
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwaxsystems.com
>
> On Tue, Feb 28, 2017 at 2:27 PM, Rishi Solanki <rishisolankii@gmail.com>
> wrote:
>
>> Interesting related blog - LINK
>> <https://blog.sqlauthority.com/2014/02/14/mysql-when-to-
>> use-timestamp-or-datetime-difference-between-timestamp-or-datetime/>
>> One more conversation -
>> http://stackoverflow.com/questions/5989539/when-to-use-
>> datetime-or-timestamp
>>
>> It says it depends on the context of the field for which it is used.
>> DATETIME seems to be good choice as we will be updating field type, and it
>> may applicable to many places.
>>
>> Thanks!
>>
>>
>> Rishi Solanki
>> Sr. Manager, Enterprise Software Development
>> HotWax Systems Pvt. Ltd.
>> Direct: +91-9893287847
>> http://www.hotwaxsystems.com
>>
>> On Fri, Feb 24, 2017 at 3:37 PM, Taher Alkhateeb <
>> slidingfilaments@gmail.com
>>> wrote:
>>> 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 <
>>> jacques.le.roux@les7arts.com> 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
>>>>
>>>>