Archives of the TeradataForum

Message Posted: Mon, 10 Jan 2005 @ 14:06:57 GMT

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

Hi All,

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.

Regards,

Prasanna .

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