Example SQL to filter for any records that have changed within the last 7 days:
SELECT *
FROM eas_flat_file_export
WHERE (base_address_create_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
OR (base_address_retire_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
OR (unit_address_create_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
OR (unit_address_retire_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
OR (address_x_parcel_create_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
OR (address_x_parcel_retire_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'));
More content to follow.
0 Comments