Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
You need to apply a format during the cast, either Teradata style: or Oracle style: Btw, I added DATE in front of the string, it’s the recommended (and always reliable) way to write a date literal.