All Forums Teradata Applications
NBGTD 2 posts Joined 06/13
11 Feb 2014
Why is a CAST required in this statement.

SELECT  CAST(INTERVAL '1223' second as interval  hour TO second)
 

dnoeth 4628 posts Joined 11/04
11 Feb 2014

Because you want to change the datatype?
How should the parser know what you want?
INTERVAL MINUTE
INTERVAL MINUTE TO SECOND
INTERVAL HOUR TO SECOND
...

Dieter

You must sign in to leave a comment.