Coalesce for Date in Teradata

  1. Forget Code
  2. Teradata
  3. Coalesce for Date
Date cannot be coalesce directly, coalesce function accepts string as argument. To overcome this, cast date to varchar and apply coalesce

COALESCE(CAST(DateColumn AS VARCHAR(10)),'Date is NULL')


To cast as default date
COALESCE(CAST(DateColumn AS VARCHAR(10)),'2012-01-30')