Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 13:40:39 GMT

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

Hello

How is it possible to do coalesce or null tests on date fields?

When I do

case when DATE_OUVR_PRDT_SERV is null then '0001-01-01' else
DATE_OUVR_PRDT_SERV end
or
coalesce (DATE_OUVR_PRDT_SERV,'101')

I get the following error : 3800 Datatype mismatch in then/else expression

Thanks for your reply

Bests regards,

Philippe VILLENEUVE
CTRCEAPC

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