SHARE
TWEET

Untitled

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