Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 13:55:13 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

The reason for the 3800 Data type mismatch, is because the '101' contained within your coalesce statement is not a date type, try something like

COALESCE(DATE_OUVR_PRDT_SERV, DATE '2000-01-01')

Regards

Matthew Winter

Technical Architect
TPG IS, Design Authority
Teradata Certified Professional

	<Prev	Next>		<<First	<Prev	Next>	Last>>