Sometimes it is necessary to calculate the offset for the current timezone. Therefore you can use this helpful snippet:
SET @tzOffset = (UNIX_TIMESTAMP()-UNIX_TIMESTAMP(CONVERT_TZ(NOW(), 'Etc/UTC', 'Europe/Berlin')));
That’s it.
Advanced Invoice Layout Extension
89 €*
This Magento Extension offers customizable templates for PDF invoices, shipments and creditmemos that can be send via email to your customers.
read more
Post Comments to "How to calculate MySQL timezone offset"