How should I format a string to cast into a date (PostgreSQL) datatype?
I receive a date from a from with this format = dd/mm/yyyy or dd-mm-yyyy
INSERT INTO table VALUES (to_date(translate($date, '-', '/'), 'DD/MM/YYYY'))