Archives of the TeradataForum

Message Posted: Wed, 19 Jul 2006 @ 16:24:35 GMT

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

Hi Guys,

What is the most efficient way to add hours as integer to a date field? I have 2 columns one is integer and another as time and I need to add them. I know that I can use the extract function and do MOD to perform the same in a conditional statement. Is there any better way?

Thanks, Vivek

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