Archives of the TeradataForum

Message Posted: Thu, 11 Aug 2005 @ 20:32:05 GMT

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

Simon,

Don't know which way is faster

You can create a timestamp column

Just replace current_date and current_time with your date and time columns

You may have to adjust for sub seconds.

     min(cast(current_date || ' ' || cast(current_time  as char(8)) as
     timestamp(0)))

Thanks,

Bob Diehl

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