Now using timestamps with timezones

[dmarc.git] / dmarc_to_database

diff --git a/dmarc_to_database b/dmarc_to_database
index a8141fdc108478097cc290e86890901c59cb6fd5..530d548b984fa8267eb57c46cfbacdf983441c1b 100755 (executable)
--- a/dmarc_to_database
+++ b/dmarc_to_database
@@ -87,10 +87,10 @@ field_maps = {'./policy_published/adkim': {'pg_field_name': 'policy_published_ad
   'pg_type': 'inet'},
  './report_metadata/date_range/begin': {'pg_field_name': 'report_metadata_date_range_begin',
   'pg_table': 'reports',
-  'pg_type': 'timestamp'},
+  'pg_type': 'timestamptz'},
  './report_metadata/date_range/end': {'pg_field_name': 'report_metadata_date_range_end',
   'pg_table': 'reports',
-  'pg_type': 'timestamp'},
+  'pg_type': 'timestamptz'},
  './report_metadata/email': {'pg_field_name': 'report_metadata_email',
   'pg_table': 'reports',
   'pg_type': 'varchar'},