Pass DATE NULL to Stored Procedure.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a date parameter, and i want to pass Date as NULL to the stored
procedure, I dont know how to pass null for the date field.

All suggestions welcome and appreciated.
 
In addition to Miha's solution, you can also set the parameter's default
value to null in SP. If you don't pass the parameter value to SP, it takes
null.

HTH

Elton Wang
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing OracleDateTime.null.value to store procedure??? 2
C# passes parameter but return value always -1 3
How to pass a null value for a stored procedure? 3
TableAdapter, stored procedure, optional parameters 0
Passing parameter to store SQL procedure ??? 2
passing date values 6
>> adodb.parameter to handle nulls 2
SQLDataAdapter problem framing dates 1

Back
Top