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!
user
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](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/language_for_defining_and_processing_data_vql/data_types/data_types_for_dates_timestamps_and_intervals#data-types-for-dates-timestamps-and-intervals) **and** [Arithmetic Operators for Datetime and Interval Values](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/language_for_defining_and_processing_data_vql/data_types/data_types_for_dates_timestamps_and_intervals#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