Grid result not match the export result in magento 2
I created a module for some data logging with widget grid display and csv export function.
Inside the collection, I added a new columns with mysql function "IF(DATE_FORMAT(updated_at,'%H:%i') = '16:30',DATE_FORMAT(updated_at,'%Y-%m-%d'),'')"
The result is correct in the exported csv but not for grid.
magento-2.1 sql import-products
edited 27 mins ago
Teja Bhagavan Kollepara
2,96341847
asked Jun 15 '17 at 4:21
Alex TangAlex Tang
61
add a comment |
I created a module for some data logging with widget grid display and csv export function.
Inside the collection, I added a new columns with mysql function "IF(DATE_FORMAT(updated_at,'%H:%i') = '16:30',DATE_FORMAT(updated_at,'%Y-%m-%d'),'')"
The result is correct in the exported csv but not for grid.
magento-2.1 sql import-products
edited 27 mins ago
Teja Bhagavan Kollepara
2,96341847
asked Jun 15 '17 at 4:21
Alex TangAlex Tang
61
add a comment |
I created a module for some data logging with widget grid display and csv export function.
Inside the collection, I added a new columns with mysql function "IF(DATE_FORMAT(updated_at,'%H:%i') = '16:30',DATE_FORMAT(updated_at,'%Y-%m-%d'),'')"
The result is correct in the exported csv but not for grid.
magento-2.1 sql import-products
edited 27 mins ago
Teja Bhagavan Kollepara
2,96341847
asked Jun 15 '17 at 4:21
Alex TangAlex Tang
61
I created a module for some data logging with widget grid display and csv export function.
Inside the collection, I added a new columns with mysql function "IF(DATE_FORMAT(updated_at,'%H:%i') = '16:30',DATE_FORMAT(updated_at,'%Y-%m-%d'),'')"
The result is correct in the exported csv but not for grid.
magento-2.1 sql import-products
magento-2.1 sql import-products
edited 27 mins ago
Teja Bhagavan Kollepara
2,96341847
asked Jun 15 '17 at 4:21
Alex TangAlex Tang
61
edited 27 mins ago
Teja Bhagavan Kollepara
2,96341847
asked Jun 15 '17 at 4:21
Alex TangAlex Tang
61
edited 27 mins ago
Teja Bhagavan Kollepara
2,96341847
edited 27 mins ago
Teja Bhagavan Kollepara
2,96341847
edited 27 mins ago
Teja Bhagavan Kollepara
2,96341847
2,96341847
asked Jun 15 '17 at 4:21
Alex TangAlex Tang
61
asked Jun 15 '17 at 4:21
Alex TangAlex Tang
61
asked Jun 15 '17 at 4:21
Alex TangAlex Tang
61
61
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
First of all, your Magento do NOTHING wrong.
Most probably you didn't set the correct timezone in DB. If you didn't set it, the time will be treated as UTC. And you definitely set GMT+8 in Magento, so you can notice that the time in Magento is 8 hours greater than the time in CSV.
For DB side, check the timezone setting first by running this SQL:
SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);
If it returns 00:00:00 it means your timezone is set to UTC on DB side. To fix it, run this command:
SET time_zone = 'Asia/Hong_Kong';
Of course, you may need to re-import the products if the time doesn't show correctly.
edited Jul 27 '17 at 10:26
Teja Bhagavan Kollepara
2,96341847
answered Jun 15 '17 at 5:29
PY YickPY Yick
1,729721
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f179096%2fgrid-result-not-match-the-export-result-in-magento-2%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
First of all, your Magento do NOTHING wrong.
Most probably you didn't set the correct timezone in DB. If you didn't set it, the time will be treated as UTC. And you definitely set GMT+8 in Magento, so you can notice that the time in Magento is 8 hours greater than the time in CSV.
For DB side, check the timezone setting first by running this SQL:
SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);
If it returns 00:00:00 it means your timezone is set to UTC on DB side. To fix it, run this command:
SET time_zone = 'Asia/Hong_Kong';
Of course, you may need to re-import the products if the time doesn't show correctly.
edited Jul 27 '17 at 10:26
Teja Bhagavan Kollepara
2,96341847
answered Jun 15 '17 at 5:29
PY YickPY Yick
1,729721
add a comment |
First of all, your Magento do NOTHING wrong.
Most probably you didn't set the correct timezone in DB. If you didn't set it, the time will be treated as UTC. And you definitely set GMT+8 in Magento, so you can notice that the time in Magento is 8 hours greater than the time in CSV.
For DB side, check the timezone setting first by running this SQL:
SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);
If it returns 00:00:00 it means your timezone is set to UTC on DB side. To fix it, run this command:
SET time_zone = 'Asia/Hong_Kong';
Of course, you may need to re-import the products if the time doesn't show correctly.
edited Jul 27 '17 at 10:26
Teja Bhagavan Kollepara
2,96341847
answered Jun 15 '17 at 5:29
PY YickPY Yick
1,729721
add a comment |
First of all, your Magento do NOTHING wrong.
Most probably you didn't set the correct timezone in DB. If you didn't set it, the time will be treated as UTC. And you definitely set GMT+8 in Magento, so you can notice that the time in Magento is 8 hours greater than the time in CSV.
For DB side, check the timezone setting first by running this SQL:
SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);
If it returns 00:00:00 it means your timezone is set to UTC on DB side. To fix it, run this command:
SET time_zone = 'Asia/Hong_Kong';
Of course, you may need to re-import the products if the time doesn't show correctly.
edited Jul 27 '17 at 10:26
Teja Bhagavan Kollepara
2,96341847
answered Jun 15 '17 at 5:29
PY YickPY Yick
1,729721
First of all, your Magento do NOTHING wrong.
Most probably you didn't set the correct timezone in DB. If you didn't set it, the time will be treated as UTC. And you definitely set GMT+8 in Magento, so you can notice that the time in Magento is 8 hours greater than the time in CSV.
For DB side, check the timezone setting first by running this SQL:
SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);
If it returns 00:00:00 it means your timezone is set to UTC on DB side. To fix it, run this command:
SET time_zone = 'Asia/Hong_Kong';
Of course, you may need to re-import the products if the time doesn't show correctly.
edited Jul 27 '17 at 10:26
Teja Bhagavan Kollepara
2,96341847
answered Jun 15 '17 at 5:29
PY YickPY Yick
1,729721
edited Jul 27 '17 at 10:26
Teja Bhagavan Kollepara
2,96341847
edited Jul 27 '17 at 10:26
Teja Bhagavan Kollepara
2,96341847
edited Jul 27 '17 at 10:26
Teja Bhagavan Kollepara
2,96341847
2,96341847
answered Jun 15 '17 at 5:29
PY YickPY Yick
1,729721
answered Jun 15 '17 at 5:29
PY YickPY Yick
1,729721
answered Jun 15 '17 at 5:29
PY YickPY Yick
1,729721
1,729721
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f179096%2fgrid-result-not-match-the-export-result-in-magento-2%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
