daily pastebin goal
60%
SHARE
TWEET

Untitled

a guest Nov 15th, 2017 52 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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top