Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
7 replies
Subscribers
7 subscribers
Views
2405 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi, I am executing a query through executequery() expression rule. To the q
sikhivahans
over 11 years ago
Hi,
I am executing a query through executequery() expression rule. To the query, i am passing an number(integer) input dynamically. The input numbers are like this : 1363852714818, 1363852714900 etc. But while passing the input as parameter, the query is unable to accept this much big number. Could anyone provide a solution for this asap?
Thanks in advance.....
OriginalPostID-61634
OriginalPostID-61634
Discussion posts and replies are publicly visible
Parents
0
mathanap
over 11 years ago
Change the rule input type to decimal and try the following syntax
executequery("jdbc/AppianPrimaryDS","SELECT TO_CHAR(
FROM_TZ(
CAST(to_date('1-1-1970 00:00:00','DD-MM-YYYY HH24:Mi:SS')+("&ri!epochNumber&"/86400000) AS TIMESTAMP)
, '+00:00'
)
AT TIME ZONE '+05:30'
, 'DD-MON-YYYY HH24:Mi:SS')
FROM DUAL")
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
mathanap
over 11 years ago
Change the rule input type to decimal and try the following syntax
executequery("jdbc/AppianPrimaryDS","SELECT TO_CHAR(
FROM_TZ(
CAST(to_date('1-1-1970 00:00:00','DD-MM-YYYY HH24:Mi:SS')+("&ri!epochNumber&"/86400000) AS TIMESTAMP)
, '+00:00'
)
AT TIME ZONE '+05:30'
, 'DD-MON-YYYY HH24:Mi:SS')
FROM DUAL")
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data