Archives of the TeradataForum

Message Posted: Wed, 26 Feb 2003 @ 11:26:12 GMT

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

John

I have had no end of fun (?) with timestamp and interval with similar errors to yours. I have found that when CASTing to an interval its a good idea to specify the maximum number of digits such as HOUR(3)

Try sel cast('123' as INTERVAL HOUR);

SEL CAST ('123' as INTERVAL HOUR(3));

Howard

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