Sequelize Date column still return as UTC when useUTC: false
I'm using nestjs, sequelize-typescript and postgresql database.
When I Post data, it saved correctly with timezone (+07:00)
But when I get the data, the date column returned as UTC timezone.
For example, I post this date
2018-11-22 17:00:00
In the database, it saved as
2018-11-22 17:00:00 +7
But when I get/call the data, it gives me this result
2018-11-22T10:00:00.000Z
I have been trying to google it a whole day and most people suggest to add this line in the database config
timezone: '+07:00',
dialectOptions: {
useUTC: false
}
But it still not working.
postgresql sequelize.js nestjs sequelize-typescript
asked Nov 22 '18 at 11:11
Deny Kristianto PamujiDeny Kristianto Pamuji
32
add a comment |
I'm using nestjs, sequelize-typescript and postgresql database.
When I Post data, it saved correctly with timezone (+07:00)
But when I get the data, the date column returned as UTC timezone.
For example, I post this date
2018-11-22 17:00:00
In the database, it saved as
2018-11-22 17:00:00 +7
But when I get/call the data, it gives me this result
2018-11-22T10:00:00.000Z
I have been trying to google it a whole day and most people suggest to add this line in the database config
timezone: '+07:00',
dialectOptions: {
useUTC: false
}
But it still not working.
postgresql sequelize.js nestjs sequelize-typescript
asked Nov 22 '18 at 11:11
Deny Kristianto PamujiDeny Kristianto Pamuji
32
how are you querying the database?
– Rahul Sharma
Nov 25 '18 at 11:09
I'm using built-in sequelize function, like findbyid, and findone. if look into the log, it just execute simple select with join.
– Deny Kristianto Pamuji
Nov 26 '18 at 9:07
add a comment |
I'm using nestjs, sequelize-typescript and postgresql database.
When I Post data, it saved correctly with timezone (+07:00)
But when I get the data, the date column returned as UTC timezone.
For example, I post this date
2018-11-22 17:00:00
In the database, it saved as
2018-11-22 17:00:00 +7
But when I get/call the data, it gives me this result
2018-11-22T10:00:00.000Z
I have been trying to google it a whole day and most people suggest to add this line in the database config
timezone: '+07:00',
dialectOptions: {
useUTC: false
}
But it still not working.
postgresql sequelize.js nestjs sequelize-typescript
asked Nov 22 '18 at 11:11
Deny Kristianto PamujiDeny Kristianto Pamuji
32
I'm using nestjs, sequelize-typescript and postgresql database.
When I Post data, it saved correctly with timezone (+07:00)
But when I get the data, the date column returned as UTC timezone.
For example, I post this date
2018-11-22 17:00:00
In the database, it saved as
2018-11-22 17:00:00 +7
But when I get/call the data, it gives me this result
2018-11-22T10:00:00.000Z
I have been trying to google it a whole day and most people suggest to add this line in the database config
timezone: '+07:00',
dialectOptions: {
useUTC: false
}
But it still not working.
postgresql sequelize.js nestjs sequelize-typescript
postgresql sequelize.js nestjs sequelize-typescript
asked Nov 22 '18 at 11:11
Deny Kristianto PamujiDeny Kristianto Pamuji
32
asked Nov 22 '18 at 11:11
Deny Kristianto PamujiDeny Kristianto Pamuji
32
asked Nov 22 '18 at 11:11
Deny Kristianto PamujiDeny Kristianto Pamuji
32
asked Nov 22 '18 at 11:11
Deny Kristianto PamujiDeny Kristianto Pamuji
32
asked Nov 22 '18 at 11:11
Deny Kristianto PamujiDeny Kristianto Pamuji
32
32
how are you querying the database?
– Rahul Sharma
Nov 25 '18 at 11:09
I'm using built-in sequelize function, like findbyid, and findone. if look into the log, it just execute simple select with join.
– Deny Kristianto Pamuji
Nov 26 '18 at 9:07
add a comment |
how are you querying the database?
– Rahul Sharma
Nov 25 '18 at 11:09
I'm using built-in sequelize function, like findbyid, and findone. if look into the log, it just execute simple select with join.
– Deny Kristianto Pamuji
Nov 26 '18 at 9:07
how are you querying the database?
– Rahul Sharma
Nov 25 '18 at 11:09
how are you querying the database?
– Rahul Sharma
Nov 25 '18 at 11:09
I'm using built-in sequelize function, like findbyid, and findone. if look into the log, it just execute simple select with join.
– Deny Kristianto Pamuji
Nov 26 '18 at 9:07
I'm using built-in sequelize function, like findbyid, and findone. if look into the log, it just execute simple select with join.
– Deny Kristianto Pamuji
Nov 26 '18 at 9:07
add a comment |
1 Answer
1
active
oldest
votes
See this answer. Note that 2018-11-22T10:00:00.000Z and 2018-11-22 17:00:00 +7 is a same date. Sequelize return a js Date object, that you can format as you like. By default in console you see date formated as ISO string.
answered Nov 30 '18 at 19:30
FarisFaris
1014
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f53429686%2fsequelize-date-column-still-return-as-utc-when-useutc-false%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
See this answer. Note that 2018-11-22T10:00:00.000Z and 2018-11-22 17:00:00 +7 is a same date. Sequelize return a js Date object, that you can format as you like. By default in console you see date formated as ISO string.
answered Nov 30 '18 at 19:30
FarisFaris
1014
add a comment |
See this answer. Note that 2018-11-22T10:00:00.000Z and 2018-11-22 17:00:00 +7 is a same date. Sequelize return a js Date object, that you can format as you like. By default in console you see date formated as ISO string.
answered Nov 30 '18 at 19:30
FarisFaris
1014
add a comment |
See this answer. Note that 2018-11-22T10:00:00.000Z and 2018-11-22 17:00:00 +7 is a same date. Sequelize return a js Date object, that you can format as you like. By default in console you see date formated as ISO string.
answered Nov 30 '18 at 19:30
FarisFaris
1014
See this answer. Note that 2018-11-22T10:00:00.000Z and 2018-11-22 17:00:00 +7 is a same date. Sequelize return a js Date object, that you can format as you like. By default in console you see date formated as ISO string.
answered Nov 30 '18 at 19:30
FarisFaris
1014
edited Nov 30 '18 at 19:40
answered Nov 30 '18 at 19:30
FarisFaris
1014
answered Nov 30 '18 at 19:30
FarisFaris
1014
answered Nov 30 '18 at 19:30
FarisFaris
1014
1014
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53429686%2fsequelize-date-column-still-return-as-utc-when-useutc-false%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
how are you querying the database?
– Rahul Sharma
Nov 25 '18 at 11:09
I'm using built-in sequelize function, like findbyid, and findone. if look into the log, it just execute simple select with join.
– Deny Kristianto Pamuji
Nov 26 '18 at 9:07