Breaking News: Grepper is joining You.com. Read the official announcement!

Sequelize set timezone to query

Saeed Ghanbari answered on December 7, 2022 Popularity 9/10 Helpfulness 1/10

answer Sequelize set timezone to query

Sequelize set timezone to query

Comment

const pg = require('pg')

const { types } = pg

// we must store dates in UTC
pg.defaults.parseInputDatesAsUTC = true

// fix node-pg default transformation for date types
// https://github.com/brianc/node-pg-types
// https://github.com/brianc/node-pg-types/blob/master/lib/builtins.js
types.setTypeParser(types.builtins.DATE, str => str)
types.setTypeParser(types.builtins.TIMESTAMP, str => str)
types.setTypeParser(types.builtins.TIMESTAMPTZ, str => str)

Popularity 9/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: set timezone whatever

Link to this answer
Share Copy Link

Contributed on Dec 07 2022

Saeed Ghanbari

0 Answers Avg Quality 2/10

Closely Related Answers

sequelize timezone postgers

Comment

const pg = require('pg');
const { types } = pg;
pg.defaults.parseInputDatesAsUTC = true;
types.setTypeParser(types.builtins.DATE, str => str);
types.setTypeParser(types.builtins.TIMESTAMP, str => str);
types.setTypeParser(types.builtins.TIMESTAMPTZ, str => str);

Popularity 9/10 Helpfulness 2/10 Language whatever

Source: Grepper

Tags: timezone timezon

Link to this answer
Share Copy Link

Contributed on Dec 07 2022

Saeed Ghanbari

0 Answers Avg Quality 2/10

Sequelize set timezone to query

Contents

More Related Answers

Sequelize set timezone to query

Closely Related Answers

sequelize timezone postgers

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.