ofbiz-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacques Le Roux <jacques.le.r...@les7arts.com>
Subject Re: OFBIZ-3972
Date Wed, 15 Mar 2017 06:06:26 GMT
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
>>>>
>>>>


Mime
View raw message