Archives of the TeradataForum

Message Posted: Mon, 05 Sep 2005 @ 13:54:02 GMT

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

Hi Mike:

You could try using minutes to seconds instead of just minutes. I am not very hopeful that it would solve the problem for all your data.

The other solution would be do the math twice using a fixed literal timestamp (before and after the literal) and then add the two minutes together as an integer or smallint. I have never tried this but it seems like an opportunity.

Best of luck,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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