-
Passing date in prepared statement
HI all
I am executing the below query in Db2 usin prepared statement
select days(current date) - days (date( ? )) from sysibm.sysdummy1 ;
when i passed the parameter as string it is not working
but when i execute the same query in command line processor its working fine.
select days(current date) - days (date('2006-12-01')) from sysibm.sysdummy1 ;
the above query works fine but it doesn't when i used the prepared statement.
Can any one help me out.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|