You can translate the question and the replies:

Convert a number to an INTERVAL DAY TO SECOND

Hello, Is there any possibility to achieve in Denodo something similar to NUMTODSINTERVAL Oracle function? select NUMTODSINTERVAL(0.6, 'DAY') from dual; Thank you in advance!
10-05-2022 07:59:24 -0400

1 Answer

Hello, Virtual DataPort supports the interval data types **INTERVALDAYSECOND** and **INTERVALYEARMONTH**, which can be used in arithmetic operations. An example of the use of this data type would be: ``` select INTERVAL '4 5:12:10.222' DAY TO SECOND from dual(); select INTERVAL '0 14:24' DAY TO MINUTE from dual(); ``` I would refer to the document **[Data Types for Dates, Timestamps and Intervals]( **and** [Arithmetic Operators for Datetime and Interval Values](** in which you can read more about it. Hope this helps!
Denodo Team
11-05-2022 08:19:48 -0400
You must sign in to add an answer. If you do not have an account, you can register here