title: How to suppress Teradata warnings with CAST
body: <p>Let's say I need to <code>CAST(birth_date AS DATE FORMAT 'MM/DD/YYYY')</code> </p>
  
  <p>If the <code>birth_date</code> field contains nulls or invalid characters it throws and untranslatable character error </p>
  
  <p>Of course I can use the <code>regex</code>, <code>otranslate</code> but all that overcomplicates the <code>sql</code> </p>
  
  <p><strong>Is there any way to suppress all these errors ?</strong> <code>CAST</code> if you can, otherwise make it <code>null</code>?</p>