Inconsistent data type usage in case of registering a date

Copy SQL

WITH date_cols AS (SELECT table_schema, table_name, column_name, ordinal_position, data_type
FROM INFORMATION_SCHEMA.columns
WHERE  (column_name ILIKE '%\_kp' OR (column_name ILIKE '%date' AND column_name NOT ILIKE '%update')) 
AND (table_schema, table_name) IN (SELECT table_schema, table_name
FROM INFORMATION_SCHEMA.tables WHERE table_type='BASE TABLE') 
AND table_schema NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL))
SELECT data_type, Count(*) AS nr_of_occurrences, string_agg( table_schema || '.' || table_name || '.' || column_name,';<br>' ORDER BY ordinal_position) AS columns
FROM date_cols
GROUP BY data_type
HAVING (SELECT Count(*) AS c
FROM (SELECT Count(*) AS nr_of_occurrences
FROM date_cols
GROUP BY data_type) AS foo)>1
ORDER BY Count(*) DESC, data_type;