---

SELECT
    ordinal_position,
    column_name,
    data_type
FROM information_schema.columns
WHERE table_schema = 'ourpension'
  AND table_name = 'contract'
  AND (
        data_type IN (
            'date',
            'timestamp without time zone',
            'timestamp with time zone'
        )
        OR column_name ILIKE '%date%'
        OR column_name ILIKE '%created%'
      )
ORDER BY ordinal_position;