How to adjust timestamps and timezones

Sometimes timezones and timestamps need to be adjusted because the reporting platform might report timestamps in one timezone and the user might be in another timezone.

Then the timestamps can be adjusted so the data matches.

1. Click edit datasource

2. Add a column with the adjusted timestamp

If you want to shift the time for example 1h forward enter the field definition:

purchase_date::TIMESTAMP + interval '1h'

Where purchase_date in this example is the original field.