Archives of the TeradataForum
Message Posted: Mon, 10 Jan 2005 @ 14:06:57 GMT
I am trying to find the difference between two timestamps which results in seconds
SELECT ( CAST( CAST(CURRENT_TIMESTAMP AS CHAR(19) ) AS TIMESTAMP(0))- CAST( '1970-01-01 00:00:00' AS TIMESTAMP(0)) ) DAY(4) TO SECOND
We have a metric ( Microstrategy Jargon) that makes use of above calculation. Since DAY Interval will support only 4 Decimals (9999 days = Approximately 27 Years) I am getting an Interval overflow error. Here I need to have more precision for DAY which Teradata Currently doesn't support. Is there any round about way of doing this calculation? Please help me out.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|