Mysql TimeZone - Asia/kolkata
PHP TimeZone - Asia/Kolkata
Magento 2 Config - Asia/Kolkata
lets say I have following two rows in sales_order:
I have Following Query:
select count(*) from sales_order where date(created_at) = date('2019-04-28');
Result in Mysql WorkBench:
2
Result in Magento 2 Resource Model Class:
1
I used
$this->connection->fetchAll("select count(*) from sales_order where date(created_at) = date('2019-04-28')");
for fetching data in Resource Model.
I know this created_at is getting converted to UTC. I want my query results to be in Asia/Kolkata time zone. Any help would be appreciated.
Some things i already tried:
- Changing TimeZone in bootstrap.php from UTC to required timezone.
- setting PHP TimeZone just before executing my query.
I can fix this by running a loop on result set, but i want my query to do all the work.