SQL
Timestamp with Time Zone Strings
With no time zone extension loaded, `TIMESTAMPTZ` values will be cast to and from strings
using offset notation.
This will let you specify an instant correctly without access to time zone information.
For portability, `TIMESTAMPTZ` values will always be displayed using GMT offsets:  
```sql
SELECT '2022-10-08 13:13:34-07'::TIMESTAMPTZ;
```  
```text
2022-10-08 20:13:34+00
```  
If a time zone extension such as ICU is loaded, then a time zone can be parsed from a string
and cast to a representation in the local time zone:  
```sql
SELECT '2022-10-08 13:13:34 Europe/Amsterdam'::TIMESTAMPTZ::VARCHAR;
```  
```text
2022-10-08 04:13:34-07 -- the offset will differ based on your local time zone
```