Get the result into the defined two host variavables

shiva001 · New User Joined: 19 Aug 2005 Posts: 13

Pls let me know that the following query will be run suceesfully or not?.
if not pls give me the reason.

SELECT MONTH(CURRENT TIMESTAMP - '2004-09-05') ,
YEAR( CURRENT TIMESTAMP - '2004-05-09')
INTO : WS-MONTH,
: WS-YEAR) from sysdummy1;

here the i want to get the result into the defined two host variavables
this i have to code in my program.

Pls can anyone give right answer?.

thanks?ards,
shiva

Rupesh.Kothari · Member of the Month Joined: 27 Apr 2005 Posts: 486

Hi shiva001,

Please give appropriate title line so that it can use for future reference or search.

I guess, to convert the difference into days,months or years we can use some calculation.

Regards
Rupesh