Archives of the TeradataForum

Message Posted: Fri, 24 Aug 2001 @ 13:03:49 GMT

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

This also works:

cast(cast(when_dt as char(10))||' '||cast(when_tm as char(8))
    as timestamp(0) )

and likewise:

max(cast(cast(when_dt as char(10))||' '||cast(when_tm as char(8))
    as timestamp(0) ) )

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