RTT Summary and OPA_PROPERTIES_PUBLIC recording dates are in different timezones

[Stephen Suffian]

I noticed that a change took place sometime in the last few months where there was a change to recording_date data type in the rtt_summary table.

Here is an example, which returns the following. It appears that the rtt_summary pgtype has been changed to a timestamptz from a date, which leads to a mismatch between the two columns:

query: 

select rtt_summary.recording_date as rtt_summary_recording_date, opa_properties_public.recording_date as opa_properties_public_recording_date 

from rtt_summary JOIN opa_properties_public on opa_account_num=parcel_number 

where opa_account_num = '883320000' and document_type='MORTGAGE'

{
  "rows": [
    {
      "rtt_summary_recording_date": "2017-07-18T04:00:00Z",
      "opa_properties_public_recording_date": "2017-07-18T00:00:00Z"
    }
  ],
  "time": 1.19,
  "fields": {
    "rtt_summary_recording_date": {
      "type": "date",
      "pgtype": "timestamptz"
    },
    "opa_properties_public_recording_date": {
      "type": "date",
      "pgtype": "date"
    }
  },
  "total_rows": 1
}