On does not simply set a timezone flag in props.conf for dbconnect inputs - the app appears to do timestamping before it gets to props.conf processing.
Add the following to the JVM options in the configuration tab of the DB connect app:
-Duser.timezone=GMT
A challenge with this approach is that it means that all database logs on this forwarder are ingested in GMT/UTC, so if you have different databases logging in different timezones, you'll need a different dbconnect app / forwarder combination for each one.
(Ideally we'd be able to set it on a per connection basis instead of per JVM, but it is not this day).
... View more