Archives of the TeradataForum
Message Posted: Thu, 03 Jul 2008 @ 11:27:21 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|