View previous topic :: View next topic
|
Author |
Message |
ravi1
New User
Joined: 27 Apr 2006 Posts: 11
|
|
|
|
Hi
I have coded
Exec Sql
week(current date)
into :ws_week_num
from sysibm.sysdummy1;
I am not getting correct value 11 in whatever data type i choose to declare ws_week_num. I am getting zeroes.
Please suggest how to declare ws_week_num.
Note: I already tried the following
fixed bin(31,0)
pic '9999'.
fixed dec(3)
Ur suggestions needed. |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
FIXED BIN(15) works for me.
Code: |
DCL
WEEK1 FIXED BIN(15); |
Code: |
EXEC SQL
SELECT WEEK(CURRENT DATE) INTO :WEEK1
FROM SYSIBM.SYSDUMMY1; |
|
|
Back to top |
|
|
|