Why is a CAST required in this statement.

Teradata Applications
Fan

Why is a CAST required in this statement.

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

1 REPLY
Senior Apprentice

Re: Why is a CAST required in this statement.

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

...