We should use Timestamp With Time Zone

[jberkus]

Currently all timestamps in the database are TIMESTAMP WITHOUT TIME ZONE. This prevents the user from easily querying the database in their own local time zone, which leads to confusion when the user compares the timestamp they see in the Github/lab UI with the timestamp they see in the database. Further, it may be causing data issues if the GH API and the GL API are not using the same timezone (are they?).

We should figure out what time zone each of github and gitlab are using, and store them as TIMESTAMPTZ.

[sgoggins]

There are timestamps with timezones on the commit table. We can make this a standard as well.

[sgoggins]

This commits table is possible because we analyze commits doing the gitlog ... surely something similar is possible with the API's

[jberkus]

For GH: https://developer.github.com/changes/26/

[sgoggins]

OK ... that's a very nice update to the GitHub API since we first started working with Augur!

[kaxada]

@sgoggins does this still need solving?