187473 - no subject - Hi,\n\nI have created a Oracle SQL view

Hi,

I have created a Oracle SQL view and one of the column is a difference of date and time, the data type shown in the view description is of Interval Day To Second. Now what is the corresponding type I have to give while creating the custom data type in Appian. I would be using this column for calculating the Average, aggregation function [AVG] in a!queryEntity works for data types [[Number (Integer), Number (Decimal), Interval (Day to Second)]].

Thanks,
Madhu

OriginalPostID-187473

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data