[How to] Clean Date Format inconsistency using Regex in Presto SQL
Background Have you ever come across date column in the table that has a different format in the same column? some row has DD/MM/YYYY. Some has YYYY-MM-DD then when you want to cast a...