I am a newbie in Teradata. I need to check a date column has valid date in case statement. This column is in "YYYY-MM-DD" format. If this field is invalid need to use '1900-01-01' as default. Can anyone please guide me on this?
an invalid date occurs when attempting to insert an erroneous date value (character chain or number) in a DATE DATATYPE column. You should consider the DATATYPE and the FORMAT.
have a look at the docs (http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/General_Reference/B035_1096_111A/...).