Drizzle storing -1 hour in TIMESTAMP
Hey guys, im having an issue with timestamp column using Postgres database. When logging a date I get correct current time, however after storing it in database, there is one hour less... I have set my database to +1 time zone
this is how the column is defined:
I have tried setting the timestamp option
this is how i set the column data:
then
I can just add one hour to the
using node-postgres
this is how the column is defined:
expectedTimeDone: timestamp('expected_time_done').notNull(),I have tried setting the timestamp option
withTimezone: truethis is how i set the column data:
const expectedDone = new Date();
// Expected done: Thu Jan 18 2024 02:46:07 GMT+0100 (Central European Standard Time)
expectedDone.setMinutes(expectedDone.getMinutes() + newTask.duration);
// Expected done after adding minutes: Thu Jan 18 2024 02:46:07 GMT+0100 (Central European Standard Time) then
db.insert(table).values({expectedTimeDone: expectedDone}) I can just add one hour to the
expectedDoneusing node-postgres
