Odbcloader and date/time/timestamp columns
I am using odbcloader with Informix IDS and it works great - for the most part. The only issue I could find so far is that date/time/timestamp columns in the source-db seem to be considered GMT and then converted to local timezone. In my case, this yields a shift of -1 hour (I am living in Germany) . I do not knot whether it is possible to specify the local timezone to odbc, but in my opinion a date/time/timestamp values should simply be copied to the same value in vertica. I could figure out why that happens and would like to share a workaround/fix. Does anybody know how to contact the maintainer(s) ?
Thanks in advance