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.....

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 11 years ago

@mathanp
I don't need to store any number.The scenario is as follows: I need to pass a number(which is timestamp of oracle) and convert into datetime format. For this the number needed to be passed exactly.
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 sikhivahans over 11 years ago

@mathanp
I don't need to store any number.The scenario is as follows: I need to pass a number(which is timestamp of oracle) and convert into datetime format. For this the number needed to be passed exactly.
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