Problem with timestamp in postgres

[victj99]

Hello, i´m having problems with timestamp in postgres. When I save a timestamped date in the database the saved date is incorrect and also when i run a select query the selected date is wrong.

If I run the insert query manually then the date is saved correctly, but when I do the select it still shows the wrong date.

Code_6RMAEaycCG.mp4

How can I solve it?

Repo link: https://github.com/victj99/pg-date-test

Thanks.

[baoletrangia]

I believe this issue is related to the timezone. Have you tried to add timezone to your timestamp column? It should look like this:
timestampTest: timestamp('timestamp_test', {mode: 'string', withTimezone: true})