[Skip to main content](#vessel-content)

#   edit other field that date field change the date field value ( only second)

##

- **[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")**
- [![lionel75's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11856-lionel75 "View lionel75's Profile") Topic Author
- [ Offline](/forum/user/11856-lionel75)

Less More

- Posts: 846
- Thank you received: 92
-
-

9 years 11 months ago -  9 years 11 months ago [\#256185](#256185) by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")  *[edit other field that date field change the date field value ( only second)](/forum/3-bug-report/887663-edit-other-field-that-date-field-change-the-date-field-value-only-second#256185 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 -- PHP version -- : 5.5  Hi I use unix timestamp storage default date field ( product&#95;sale&#95;start product&#95;sale&#95;end). When i edit a product that mean i change the value of a field that is not product&#95;sale&#95;start then when i click on save button then the second value of this field change. Since i try filter on that field then my result is random and nothing work !!  Could you please fix that bug that when edit a product without change manually by keyboard the field date that the value second attach to that field don't change . the year mont day value stay to the same value only second change !!! The second can't be edit using the date picker only manually but here i don't change the date value anymore nor by hand/keyborad or by date picker !!  How joomla could be stable if date is store in unix format and second is define by random !! Why hikashop in joomla 3 dont use joomla date picker that support more ( hour minute ) than the hikashop picker I m not a core developper but why the second are random beetween the web page form and the rdbms unix timestamp ?")* was created by *[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")*

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.2
-- PHP version -- : 5.5

Hi
I use unix timestamp storage default date field ( product_sale_start product_sale_end).
When i edit a product that mean i change the value of a field that is not product_sale_start then when i click on save button then the second value of this field change. Since i try filter on that field then my result is random and nothing work !!

Could you please fix that bug that when edit a product without change manually by keyboard the field date that the value second attach to that field don't change . the year mont day value stay to the same value only second change !!! The second can't be edit using the date picker only manually but here i don't change the date value anymore nor by hand/keyborad or by date picker !!

How joomla could be stable if date is store in unix format and second is define by random !!
Why hikashop in joomla 3 dont use joomla date picker that support more ( hour minute ) than the hikashop picker
I m not a core developper but why the second are random beetween the web page form and the rdbms unix timestamp ?

I test on joomla article and edit other field than date don't change the second value in the article edit page mode !!

####  Attachment not found

Last edit: 9 years 11 months ago by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84ODc2NjMtZWRpdC1vdGhlci1maWVsZC10aGF0LWRhdGUtZmllbGQtY2hhbmdlLXRoZS1kYXRlLWZpZWxkLXZhbHVlLW9ubHktc2Vjb25kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")**
- [![lionel75's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11856-lionel75 "View lionel75's Profile") Topic Author
- [ Offline](/forum/user/11856-lionel75)

Less More

- Posts: 846
- Thank you received: 92
-
-

9 years 11 months ago [\#256192](#256192) by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")  Replied by *[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")* on topic *[edit other field that date field change the date field value ( only second)](/forum/3-bug-report/887663-edit-other-field-that-date-field-change-the-date-field-value-only-second#256192 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 -- PHP version -- : 5.5  Hi I use unix timestamp storage default date field ( product&#95;sale&#95;start product&#95;sale&#95;end). When i edit a product that mean i change the value of a field that is not product&#95;sale&#95;start then when i click on save button then the second value of this field change. Since i try filter on that field then my result is random and nothing work !!  Could you please fix that bug that when edit a product without change manually by keyboard the field date that the value second attach to that field don't change . the year mont day value stay to the same value only second change !!! The second can't be edit using the date picker only manually but here i don't change the date value anymore nor by hand/keyborad or by date picker !!  How joomla could be stable if date is store in unix format and second is define by random !! Why hikashop in joomla 3 dont use joomla date picker that support more ( hour minute ) than the hikashop picker I m not a core developper but why the second are random beetween the web page form and the rdbms unix timestamp ?")*

for give some information of how date change in the rdbms .
1498593600 after save become 1498590000

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84ODc2NjMtZWRpdC1vdGhlci1maWVsZC10aGF0LWRhdGUtZmllbGQtY2hhbmdlLXRoZS1kYXRlLWZpZWxkLXZhbHVlLW9ubHktc2Vjb25kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

9 years 11 months ago [\#256193](#256193) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[edit other field that date field change the date field value ( only second)](/forum/3-bug-report/887663-edit-other-field-that-date-field-change-the-date-field-value-only-second#256193 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 -- PHP version -- : 5.5  Hi I use unix timestamp storage default date field ( product&#95;sale&#95;start product&#95;sale&#95;end). When i edit a product that mean i change the value of a field that is not product&#95;sale&#95;start then when i click on save button then the second value of this field change. Since i try filter on that field then my result is random and nothing work !!  Could you please fix that bug that when edit a product without change manually by keyboard the field date that the value second attach to that field don't change . the year mont day value stay to the same value only second change !!! The second can't be edit using the date picker only manually but here i don't change the date value anymore nor by hand/keyborad or by date picker !!  How joomla could be stable if date is store in unix format and second is define by random !! Why hikashop in joomla 3 dont use joomla date picker that support more ( hour minute ) than the hikashop picker I m not a core developper but why the second are random beetween the web page form and the rdbms unix timestamp ?")*

Here a screenshot from an official Joomla 3.6.4 website and his official date picker.
[ pasteboard.co/2Gg67g3EC.png](http://pasteboard.co/2Gg67g3EC.png)

Here the official Calendar in the Joomla core :
[ github.com/joomla/joomla-cms/blob/stagin...ndar-uncompressed.js](https://github.com/joomla/joomla-cms/blob/staging/media/system/js/calendar-uncompressed.js)

And here the future Calendar in Joomla core :
[ github.com/joomla/joomla-cms/pull/11138](https://github.com/joomla/joomla-cms/pull/11138)

Before making any kind of criticism ; please be sure that your test and your request are right founded.
And you should also not forget that a part of the HikaShop team is following closely the development of the Joomla core and also provide patchs and improvements...

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84ODc2NjMtZWRpdC1vdGhlci1maWVsZC10aGF0LWRhdGUtZmllbGQtY2hhbmdlLXRoZS1kYXRlLWZpZWxkLXZhbHVlLW9ubHktc2Vjb25kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")**
- [![lionel75's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11856-lionel75 "View lionel75's Profile") Topic Author
- [ Offline](/forum/user/11856-lionel75)

Less More

- Posts: 846
- Thank you received: 92
-
-

9 years 11 months ago -  9 years 11 months ago [\#256242](#256242) by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")  Replied by *[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")* on topic *[edit other field that date field change the date field value ( only second)](/forum/3-bug-report/887663-edit-other-field-that-date-field-change-the-date-field-value-only-second#256242 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 -- PHP version -- : 5.5  Hi I use unix timestamp storage default date field ( product&#95;sale&#95;start product&#95;sale&#95;end). When i edit a product that mean i change the value of a field that is not product&#95;sale&#95;start then when i click on save button then the second value of this field change. Since i try filter on that field then my result is random and nothing work !!  Could you please fix that bug that when edit a product without change manually by keyboard the field date that the value second attach to that field don't change . the year mont day value stay to the same value only second change !!! The second can't be edit using the date picker only manually but here i don't change the date value anymore nor by hand/keyborad or by date picker !!  How joomla could be stable if date is store in unix format and second is define by random !! Why hikashop in joomla 3 dont use joomla date picker that support more ( hour minute ) than the hikashop picker I m not a core developper but why the second are random beetween the web page form and the rdbms unix timestamp ?")*

You don'think my capture screen are not real or is fake !! The capture screen come from my webserver with joomla 3.6.2 and hikashop 2.6.4 . what i see is that date picker in joomla manage minute second and not the date picker that appear when edit hikashop product .. it is the reality nothing virtual ....

Last edit: 9 years 11 months ago by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84ODc2NjMtZWRpdC1vdGhlci1maWVsZC10aGF0LWRhdGUtZmllbGQtY2hhbmdlLXRoZS1kYXRlLWZpZWxkLXZhbHVlLW9ubHktc2Vjb25kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

9 years 11 months ago [\#256246](#256246) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[edit other field that date field change the date field value ( only second)](/forum/3-bug-report/887663-edit-other-field-that-date-field-change-the-date-field-value-only-second#256246 "-- HikaShop version -- : 2.6.4 -- Joomla version -- : 3.6.2 -- PHP version -- : 5.5  Hi I use unix timestamp storage default date field ( product&#95;sale&#95;start product&#95;sale&#95;end). When i edit a product that mean i change the value of a field that is not product&#95;sale&#95;start then when i click on save button then the second value of this field change. Since i try filter on that field then my result is random and nothing work !!  Could you please fix that bug that when edit a product without change manually by keyboard the field date that the value second attach to that field don't change . the year mont day value stay to the same value only second change !!! The second can't be edit using the date picker only manually but here i don't change the date value anymore nor by hand/keyborad or by date picker !!  How joomla could be stable if date is store in unix format and second is define by random !! Why hikashop in joomla 3 dont use joomla date picker that support more ( hour minute ) than the hikashop picker I m not a core developper but why the second are random beetween the web page form and the rdbms unix timestamp ?")*

Hi,

The Joomla calendar do not handle minutes.
HikaShop is using the Joomla calendar from the Joomla core.
Subject closed.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84ODc2NjMtZWRpdC1vdGhlci1maWVsZC10aGF0LWRhdGUtZmllbGQtY2hhbmdlLXRoZS1kYXRlLWZpZWxkLXZhbHVlLW9ubHktc2Vjb25kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.082 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
