Also, to be pedantic, '' wouldn't be a string - it's a datetime. If you are going to suggest the use of a new in-built function it's worth mentioning that the function wasn't introduced until SQL Server and it doesn't work with the Express version of Not sure of the relevance of talking about ADO - as SQL Server has been tagged it would make more sense to use SqlParameter, I would only use datetime2 if you need the extra precision going back to the 's.
I've never passed the size for date parameters. I could not pass datetime parameter to a stored procedure, where datatime parameter was being used in dynamic sql query, the lesson I have learned: 1. Posted Jan am Masud Ahmed. Somewhat off-topic for this question - this answers the un-asked question "how do I use a datetime variable in dynamic sql"..
Posted 1-Apr pm Member Hi, The problem is with the data type. You have to mention it as date instead of datetime. When it is datetime, you are expected to add the time along with the date. So, change the data type in the main query while you create the procedure. Posted Jul am Member Richard MacCutchan Jul pm.
This question was resolved seven years ago. Please focus on current open questions. CHill60 Jul am. If you declare a datetime variable and only assign the date part, the time is automatically set to midnight. The information in this question is insufficient. Add a comment. Active Oldest Votes. Improve this answer. Martin Smith Martin Smith k 81 81 gold badges silver badges bronze badges. Sachin Shanbhag Sachin Shanbhag Sign up or log in Sign up using Google.
Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Add " date", SqlDbType. LukeH LukeH k 53 53 gold badges silver badges bronze badges.
Be clear and specific! Try this If you are using class and its property and those property values are used as parameter then you can do this chnage the signature of the property to public DateTime? Add " date", DBNull. Value , the ADO. NET runtime doesn't know what type you want it to be This is an example.
It's work for me if obj. Add "dateParameter", SqlDbType. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. This is not a query, it is a stored procedure that has a date parameter that has a default value null.
Might want to change the default value to a hardcoded value that precedes any date in your systems. You must be logged in to reply to this topic. Login to reply. March 13, at am I have a stored procedure that has a parameter of date named dateStored.
The default value is null.
0コメント