Questions tagged [timezone]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
2answers
73 views

Magento 2 Data Migration time difference?

We have migrated M1 customers and orders from M2.3.1 successfully with the datamigration tool but we are facing some discrepancy with the time differences. The best example is customer create_at &...
0
votes
2answers
78 views

Magento 2 - Admin grid and export use different timezone

I'm using Magento 2. So, I created a Adminhtml data grid in a custom module. The problem is that the data grid doesn't match the exported data. I've set the timezone, but it seems data grid and ...
0
votes
1answer
34 views

Magento 2 - Orders saving as local timzezone

I have an issue with how a Magento 2 store is saving orders. My understanding was that orders are saved in UTC. However, when new orders are placed, it is saving them as our local timezone in the ...
1
vote
2answers
44 views

M2 | How to configure store's timezone to set date as I am getting wrong date in magento?

I get different date from todays date. I tried below ways and all give difference in time: 1) \Magento\Catalog\Block\Product\Context $contexts, .......... .......... $this->...
1
vote
2answers
158 views

How to add/subtract month to/from date in Magento2?

I am getting date by injecting this class in constructor \Magento\Framework\Stdlib\DateTime\DateTime as: protected $date; public function __construct( .... \Magento\Framework\Stdlib\DateTime\DateTime ...
3
votes
1answer
50 views

order time difference from magento 1 to magento 2 after migration

I have migrated Magento 1.9.3.1 to Magento 2.3.0 I have setup timezone India Standard Time(Asia/Kolkata). After migration created_time have differences of 5:30 hours. How can I fix the issue? For ...
0
votes
0answers
46 views

Year worth of order confirmations sent after switch to daylight saving time

We just switched to daylight saving time and a years worth of order confirmations has been sent again. For example an order confirmation dating from september 14th of last year was regent as well as ...
0
votes
1answer
34 views

How to show current date and time list in dropdown in magento2.1.7?

How to show current date and time list in dropdown in magento2.1.7, As I have purchased an extension for store pickup in my magento2 site.. But the date , time functionality is not working properly, ...
0
votes
0answers
66 views

Date / time format in Magento 1.9x

I am sending and retrieving data from the Magento 1.9x SOAP web service (v2). My question is which format are date / time fields passed in the SOAP api? Also, which timezone are dates processed in the ...
0
votes
1answer
224 views

Magento2 set timezone with mysql query

I am trying to get days difference between 2 dates with mysql query with DATEDIFF function for production_days column: $collection->getSelect()->joinLeft(array('cvo' => 'cp_vendor_order'), "...
3
votes
1answer
1k views

Make magento 2 grid date column follow config timezone

I already set my timezone config to GMT+7 in backend , and i've created a custom module which will show grid in backend that has date column, the problem is the date is being save in utc format, and i ...
2
votes
1answer
281 views

Magento2: Order updated_at stored in DB in timezone CEST but delivered/transformed to UTC by $order->getUpdatedAt in Environment “crontab”

we are facing a strange behavior for value of updated_at saved in db table sales_order. Server timezone is CEST, updated_at date therefor is saved in CEST to database. This is validated. Default ...
1
vote
2answers
1k views

Magento2 convert UTC time to IST

Can anyone let me know how to change UTC time from table column to IST(Indian Standard time) programatically with Datetime format? I have currently following date time value available in UTC format ...
1
vote
1answer
532 views

Order Confirmation email: How to get order date with correct store timezone?

If I include the order date in my order confirmation email template via ... Order Date: {{var order.created_at}} ..., the resulting order confirmation emails contain the order date in UTC/GMT time. ...
0
votes
1answer
86 views

Magento set Current Timezone

My store is from Chile I'll set timezone America/Santiago from the backend. When I place the order, it gets the wrong time. I created one script and write below code. <?php require 'app/Mage....
1
vote
0answers
172 views

Custom Admin grid TimeZOne - Date issue in magento2

I have set default time zone pacific standard time(america/los_angeles) In admin gridwhen i inline edit date i take 31 aug 2018 but once it save it display 30 aug 2018. see in images: Have anyone ...
1
vote
0answers
83 views

Building javascript “Order by for same day shipping” countdown timer

I've got an online store in Magento and I want to add a countdown timer so that if a customer orders by 5pm Eastern Standard time their product will ship the same day. I need it to be freely usable in ...
1
vote
0answers
121 views

Wrong Moscow timezone in Magento 2

For Moscow, the time zone of GMT +3 should be set. But in fact, for Moscow is established GMT +4. As a result, in the whole system of Magento (in orders, email, etc.) I get time for +1 more than now. ...
0
votes
1answer
876 views

Fatal error: Call to a member function getConfigTimezone() on null Magento 2.2

I'm trying to create a helper class that will help me determine If I should present some labels like new/sale etc. I'd like to inject to it a TimezoneInterface via the constructor however $_localeDate ...
0
votes
1answer
163 views

Is it OK to modify app/Mage.php to edit the date_default_timezone_set value in magento 1.9?

Is it OK to modify app/Mage.php to edit the date_default_timezone_set value? I've modified my timezone in magento at System => General => Locale Options => Timezone, and set it to America/...
3
votes
2answers
5k views

magento 2 - getCreatedAt() returns UTC time and not local time

I am trying to get the order time, I fixed the problem with orders with wrong time stamp in admin panel. Now I am trying to get the order date in my module. The problem is $created = $order->...
1
vote
1answer
275 views

How to get client(user) browser timezone in magento 2?

How to find client(user) browser timezone in magento 2?
1
vote
0answers
86 views

Magento 2: Send email based on timezone selected by customer

I am developing extension in which I need to send email on base of selected Timezone by the customer. I have set a cron which is working fine, however, I confused about to send email on the base of ...
3
votes
1answer
526 views

Magento 2 : Wrong order created and updated date in rest api response

I am fetching the orders using Magento 2 REST api services. I am using IST timezone the dates saved in the database are in correct timezone. I have set timezone to "Asia/Kolkata". On customer ...
0
votes
1answer
58 views

getOptionTimezones with core php

In the magento when I print the getOptionTimezones I get the result as follows $data['timezone_array'] = Mage::app()->getLocale()->getOptionTimezones(); [timezone_array] => Array ...
0
votes
1answer
80 views

Magento 1.9 : How to create our own custom timezone?

I want to create my own custom timezome in magento at System -> Configuration -> General -> Locale Options -> Timezone. Can anyone help me in this ?
0
votes
3answers
2k views

Magento2 not getting current time

I have tried different options but i am not getting the current time, time shows the gmt time, but actual time setting is asia/kolkatta, any one done this, please update the answer. protected $...
0
votes
1answer
2k views

Database dates get stored in local timezone

I'm having trouble with a timezone issue and I'm looking for confirmation. Do dates get stored in the database in UTC. This seems to be th consensus I have found in other posts. For example: If ...
0
votes
2answers
920 views

date displays wrong

I am trying to display a date in the frontend. Currently the code calls the date like so <?php echo $date->date('m-d-Y', $_item->getCreatedTime()); ?> the date in the database is: 2017-...
7
votes
7answers
21k views

Convert datetime and timezone to datetime in Magento 2

How to convert datetime with timezone to datetime. I have tried multiple which are available on PHP blog. But nothing worked out. I am retrieving datetime from MySql query as 2017-01-20T13:59:19+03:00 ...
2
votes
0answers
970 views

Magento 2: Newsletter Queue Take Different Queue Start Time

I'm using Magento 2 CE Version 2.1.2 My locale is Asia/Singapore. When i queue my newsletter, it's taking different start time (or timezone). If i put now, then also it's taking 8+ hours & in ...
0
votes
1answer
156 views

Get Magento time via Javascript

I need to create a CMS page that will update information at specific times. E.g.: If now is 1pm, the page will display information X. If now is 2pm, the page will display information Y. I created a ...
0
votes
1answer
251 views

magento orders timezone issue

Magento is storing orders in UTC time, however I'd like it to be ETC. My server time is ETC already, however I believe I need to set it in magento as well. Where can I do it? Any help appreciated!
1
vote
0answers
235 views

Magento Timezone Wrong

I can't seem to work out whats going on with my Magento timezones. All my orders in the backend are processed correctly and have the correct times. The backend reports however are out by 13hrs. I've ...
13
votes
3answers
5k views

My magento 2 website is crashed: Unknown or bad timezone () error

When i am accessing my magento website i am getting errors DateTimeZone::__construct(): Unknown or bad timezone () on Block and CMS pages and all my product list pages on frontend shows 404 page ...
0
votes
1answer
283 views

What time zone should I set Magento for?

I live in KY US (Eastern Time UTC-05:00). My customers are mostly from the US. My server is in Phoenix AZ (Mountain Time UTC-07:00). If I want to try to equal out the time as best as possible for ...
4
votes
0answers
167 views

how to get visitor's UTC time not relying on store view time zone?

It is required to convert customer's (or guest visitor time zone) into UTC 0 to properly store in in database in timestamp column. In magento this often doing by relying on certain store view timezone....
0
votes
2answers
611 views

Timestamp in database 2 hours earlier

When an order is placed, the date in the Magento backend is correct. When I check the database however, the timestamp is 2 hours earlier. The server time is correct, timezone in PHP and Magento ...
1
vote
1answer
269 views

Timezone (CST6CDT) is not a known timezone Magento cannot login to admin

timezone (CST6CDT) is not a known timezone";i:1;s:3233:"#0 \app\code\core\Mage\Core\Model\Locale.php(527): Zend_Date_DateObject->setTimezone('CST6CDT') Cannot login to admin panel i get this ...
1
vote
1answer
326 views

Order time stamp off by 6 hours in the order Confirmation Email. It is CORRECT on the order itself in the Admin panel

The orders have correct date/time stamps in the Admin Panel (Sales - Orders - click an order open - under Order Date --) Apr 9, 2016 3:07:57 AM) but the time is off by exactly 6 hours in the Customer ...
5
votes
3answers
22k views

How to change Magento timezone?

I have used Magento 1.9 initially timezone was America/Los_Angeles in app/etc/config.xml file and set India/Calcutta timezone in System -> Configuration -> General -> Locale Options ->Timezone ...
1
vote
1answer
772 views

How to set Local Timezone when saving time into DB in Magento

I have applied following things to make Default time zone to my local timezone i.e. 'Asia/Calcutta' -- 1) changed in config.xml - <general> <locale> <code&...
5
votes
1answer
2k views

Magento checking order updated_at using Magento date and time

we are trying to filter out orders that were created longer than 60 minutes ago with status pending. We are having some problems with the date/time functions We tried: - date('Y-m-d H:m:s') and ...
5
votes
5answers
30k views

Get current date time used in magento for saving data

I want to get current date time which is magento used for save data into database. I searched and get this line of code, Mage::getModel('core/date')->date('Y-m-d H:i:s'); but this is not working ...
4
votes
2answers
2k views

Magento 1.9.0.1 Time Stamp Incorrect

I recently transferred servers and ever since my timestamps in Magento (both orders and help desk messages) are incorrect. I have checked all of my configuration settings, and they are correct. I have ...
2
votes
0answers
1k views

Catalog price rule doesn't apply overnight and possible incorrect time zone

Every time I update Magento I have got this probem: I have to manually applicate the catalog price rule, otherwise they don't work. I have done the following changes: File app/Mage.php: ...
0
votes
1answer
682 views

FedEx Tracking displays all dates in UTC timezone

has anyone figured out a way to display the fedex tracking screen in the correct timezones? aka, not UTC. I've set the Magento timezone and the Server Timezones correctly. It's just the fedex ...
0
votes
1answer
334 views

Random Timezone Error “timezone (Etc/UTC) is not a known timezone”

I was logging into the magento admin panel, and when I log in this sudden error appears. There has been an error processing your request timezone (Etc/UTC) is not a known timezone Trace: #0 /home/...
1
vote
0answers
779 views

Where does Magento take the time from?

I upgraded my Cloud hosting account (doubled the processor and memory) but then was getting a problem with the Session Cookie Management (after customers would log in - it would take them to a page ...
3
votes
1answer
2k views

Get Order datetime including timezone in email template

I try to modify default New Order email template. Currently, I get order datetime by {{var order.getCreatedAtFormated('short')}}. It results 6/18/2015 12:18 PM. I want to include timezone following ...