Storing dates in date fields

From time to time, ports/security/vuxml/vuln.xml gets a date field containing an invalid date. FreshPorts stores these entries in a table that looks like this: freshports.org=# \d vuxml Table “public.vuxml” Column | Type | Modifiers —————-+————–+—————————————————- id | integer | not null default nextval(‘vuxml_id_seq’::regclass) vid | text | not null topic | text | not null […]

Storing dates in date fields Read More ยป