Declare an explicit timezone

The most common method of working with timezones is to declare an explicit timezone in the view query.

1. At the psqlprompt, create the view and declare the timezone:

2. Alternatively, you can cast to a timestamp after the view using SELECT: