Has anyone here used knex? I have a problem with date

Question

Has anyone here used knex? I have a problem with date

serialization.
I use knex as my query builder, only.
When knex uses my Date object, it will use the local time version.
When all the dates in my DB are in UTC, that doesn't play well when I'm +0200.
Is there any way to tell knex to not serialize using local time?

0

07.09.2017

2 ответов

6 просмотров

Thomas

Always store dates as unix timestamps!!!!

0

07.09.2017

Yohanes Gultom · Accepted Answer

Yohanes Gultom

you can try to set timezone on your connection pool https://github.com/tgriesser/knex/issues/97 or directly set it to the connection (in case you are not using pool) https://github.com/tgriesser/knex/issues/128

0

07.09.2017

Похожие чаты

Has anyone here used knex? I have a problem with date

2 ответов

Похожие вопросы