Log entries have different timezones and formats?

[e-gineer]

It's currently 11:07pm on 2021-09-18 US Eastern time for me. I ran a query and saw the following in the logs.

First, weirdly, it's in a log file for the next day (the 19th) ~/.steampipe/logs/database-2021-09-19.log.

Second, the log has two issues:

1. The date format of log entries is different depending on the source.
2. Logs from different sources are using both local time and UTC time.

2021-09-18T23:07:28.264-0400 [WARN]  plugin.steampipe-plugin-imap.plugin: [WARN]  listMessage: Subject:="One on One Educational Services Limited - Chat with redacted@gmail.com"
2021-09-18T23:07:28.264-0400 [WARN]  plugin.steampipe-plugin-imap.plugin: [WARN]  listMessage: body="<div style=3D'background-color: rgb(241,241,241);'> <table width=3D'960' bo=
2021-09-19 03:07:28.469 GMT [55010] LOG:  duration: 2618.573 ms
2021-09-19 03:07:28.472 GMT [55010] LOG:  statement: COMMIT

[kaidaguerre]

there are now different log files for plugin and database, but we should use the same log format

[binaek]

The logging framework we use under the hood does not provide the necessary configurations to tweak the TZ of the timestamp that it uses. Currently it's always the local TZ.

We have a PR with them at hashicorp/go-hclog#104 which enabled custom time objects which will enable us to set the TZ in the timestamp that goes out.