a guest Nov 15th, 2017 50 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- I am getting the error while executing below code
- The dates are coming like below
- Where (EndDate >= '13 Nov 2017 0:0:00PM' and
- EndDate < Convert(DateTime, '13 Nov 2017 0:0:00PM')+1)
- The above is coming as a param value in the procedure
- Basically need to convert '13 Nov 2017 0:0:00PM' to datetime
- in the query.This is a `enter code here`filter condition in SP
- Is the dates coming wrong in SP or can I change it to datetime inside
- SP body.
RAW Paste Data