Steps taken to setup:
yarn
psql
create database test_timezone;
Once setup:
- Run the migration
- run
node main.js
or run the seed to see the same result. - View in the database, the
knex.fn.now()
provides a localtime instead of timestamp with tz.
Mini script for iteration:
yarn knex migrate:rollback && yarn knex migrate:latest && yarn knex seed:run