Problem with query SELECT DISTINCT a.relationid, a.eventfromid, a.eventdate AS eventfromdate, to_char(a.eventdate,'YYYY.MM.DD') AS eventdate, a.settlementid, a.settlementname, a.levelvote, a.levelvoteratio AS mapvalue, st_asgeojson(g.geom) AS geojson FROM radar.mat_individual_value_election_union a LEFT JOIN radar.individual_individual b ON b.individualid = a.candidateid JOIN radar.polygon('0', 135320) g ON g.individualid = a.settlementid WHERE a.relationid in(134858,134859) AND a.datalevel = 2 AND CASE WHEN 0 = 81311 THEN a.candidateid ELSE a.candidateid END = 0 AND a.eventdate='0' ORDER BY 1,3 desc,6
ERROR: date/time field value out of range: "0" LINE 15: JOIN radar.polygon('0', 135320) g ON g.individualid = a.s... ^ HINT: Perhaps you need a different "datestyle" setting.