product_sale_start and timezones

  • Posts: 36
  • Thank you received: 6
11 years 9 months ago #87178

Apparently product_sale_start dates are handled according to timezones while the other dates (created, modified) are not.

After setting the product_sale_start to the default time entered by the calendar control, here is what I get in the database

FROM_UNIXTIME(`product_created`) 	FROM_UNIXTIME(`product_modified`) 	FROM_UNIXTIME(`product_sale_start`) 	NOW()
2012-12-17 17:18:34 	2013-01-25 09:21:31 	2013-01-25 01:21:00 	2013-01-25 09:21:35

What is the rationale for handling product_sale_start differently than everything else?

Please Log in or Create an account to join the conversation.

  • Posts: 26152
  • Thank you received: 4027
  • MODERATOR
11 years 9 months ago #87239

Hi,

"product_created" and "product_modified" are "server local time". Because all queries which use it are launch from the server.
"product_sale_start" could be exported and is displayed to the user (and in the backend for his modification). That's why we use the Joomla timezone.

All "date_start / date_end" uses timezone. It's the same thing for the discounts.

Regards,

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

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Time to create page: 0.052 seconds
Powered by Kunena Forum