Questions tagged [timezone]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
12 views

Different Time in Database and Collection

I am Facing a Strange issue.i have some data in report_viewed_product_index table You can see this I have created a Model for this table and Getting Data But in Collection, I am getting a ...
0
votes
0answers
32 views

Magento2 - unable to set CRON timezone

I am having timezone = 'Asia/Jakarta' everywhere in Magento admin Database checked in phpinfo Server But still in the CRON logs I am getting UTC time only, I need this to be in 'Asia/Jakarta' only. ...
0
votes
0answers
30 views

How to print timezone in order confirmation email template

I am trying to print the store timezone in order confirmation email. In my email template, I have added the order date as follows, <div >{{trans ' Order Placed on <span >%created_at</...
1
vote
1answer
51 views

Magento 2.3 get current local time in phtml

I want to load the current local time in a custom phtml file, that I want to load in my CMS Page. I currently have the following code but that loads the GMC time, not my local time. How can I change ...
1
vote
2answers
203 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
167 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
50 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
157 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
431 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 ...
4
votes
1answer
80 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
1answer
41 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
1answer
329 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
394 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
784 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
113 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
196 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
135 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
128 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
939 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
180 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/...
4
votes
2answers
6k 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
305 views

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

How to find client(user) browser timezone in magento 2?
1
vote
0answers
98 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
676 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
68 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
93 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
4answers
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
1k 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
24k 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
1k 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
171 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
263 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
247 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 ...
14
votes
3answers
6k 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
325 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
171 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
652 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
278 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
385 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
24k 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
860 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
6answers
32k 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
832 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
343 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/...