Archives of the TeradataForum

Message Posted: Thu, 03 Jul 2008 @ 11:27:21 GMT

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

Hi friends, i have tried to substract two timestamps. and my expected result should be in timestamp format. iam using following query, but it is not working properly.

     select ( (cast('3999-12-31 00:00:00.0000' as timestamp(0))
                        - cast('2008-06-25 16:23:15' as timestamp(0))
                    ) );

any one,please give the exact query

Thanks,

Venkat
Larsen & Toubro Infotech Ltd.

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