View previous topic :: View next topic
|
Author |
Message |
shiva001 Warnings : 1 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 |
|
Back to top |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005 Posts: 463
|
|
|
|
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 |
|
Back to top |
|
|
|