Hi Arno.

> Aha, i oversee the fact that your output field in the case was

different

> from it's check. All your outputs are a timestamp except the ELSE

and that's

> why the engine complains ;-) A 0 (zero) cannot be converted to a

timestamp

> thus you must consider a timestamp datatype as result for the else.

For

My fault ;) I see now.

> example :
>
> (CASE
> WHEN COALESCE(EC_UsrID, 0) <> 0 THEN EC_UsrTS
> WHEN COALESCE(KV_UsrID, 0) <> 0 THEN KV_UsrTS
> WHEN COALESCE(OE_UsrID, 0) <> 0 THEN OE_UsrTS
> WHEN COALESCE(MD_UsrID, 0) <> 0 THEN MD_UsrTS
> ELSE NULL
> END) as StatusTS
>

Thank You!

>
> Regards,
> Arno Brinkman
> ABVisie

Best regards
Fikret Hasovic
TAMP R&D Team