Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

getDate() --- SQL Server --- Stored Proc call

843854Feb 18 2002 — edited Feb 19 2002

When you call stored procedure from SQL Server, how do you pass parameter for system date. I would like to pass getDate() as a paramter (like SYSDATE in Oracle) . It seems SQL Server doesn't like that.
However Oracle accepts SYSDATE as a paramter for stored proc call.

My question is as...
String qrt = "{ call me.myProc1( param1, param2, getDate() ) }" ;

Here getDate() as a one of its paramter gives problem.
Is there any other way to specity for System date.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2002

Added on Feb 18 2002

#java-database-connectivity-jdbc

1 comment

427 views