Archives of the TeradataForum

Message Posted: Fri, 23 Nov 2007 @ 13:55:49 GMT

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

Are you sure that the error is 2800? Or 3800???

If the error is 3800:

     ---------------------------
     SQL Assistant
     ---------------------------
     3800:  Datatype Mismatch in THEN/ELSE expression.
     ---------------------------
     Aceptar
     ---------------------------

One possible solution is to cast the CURRENT_TIMESTAMP to timestamp(6), so you'll get:

     select COALESCE(ins_dtm, (cast(CURRENT_TIMESTAMP as timestamp(6))))
         FROM table1;

Bye!

Castelli, Emanuel Alejandro
Desarrollo DataWarehouse - IBM Argentina

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