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

madhubindug over 8 years ago

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

Discussion posts and replies are publicly visible

Parents

0 madhubindug over 8 years ago

Hi All, I have converted the difference of two stamps into seconds which is a number and have mapped to a int in XSD, using this seconds value, i tried intervalds() to get the days, hours, min and secs value, but for this 2397484 it is returning -ve number. Any suggestions to convert the seconds value to days, hours, min and secs format.
Regards,
Madhu
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 madhubindug over 8 years ago

Hi All, I have converted the difference of two stamps into seconds which is a number and have mapped to a int in XSD, using this seconds value, i tried intervalds() to get the days, hours, min and secs value, but for this 2397484 it is returning -ve number. Any suggestions to convert the seconds value to days, hours, min and secs format.
Regards,
Madhu
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data