Add local timezone field

[schnuerle]

Create a new field in Jams and Alerts that is a date/time field adjusted to a single local timezone.

The timezone is set by the user at the time of deployment as a variable.

You may not be able to set a timezone in a database field. If not, then adjust the date time from UTC to local timezone through a query upon data ingestion.

Also have a script to back fill existing deployments with this data.

[schnuerle]

Not yet started. Could add a timestamptz data with a PostgresSQL timezone set converted from unix time and added upon insert.