Thursday, 15 May 2014

c# - Comparing current date in stored procedure -


I am trying to check a stored function in the table on a date if it is equivalent to today's date. 

  code DECLARE @ p0 datetime set @ p0 = GETDATE () * select * from testtable where dateCol = @ p0   
 it just does not work How do I do this blank lines? Thank you   
 
 
 If dateCol is only a date, no DATETIME, you can use:  < Pre>  SELECT * to table WHERE dateCol = CAST (GETDATE () AS DATE)    

 








Posted by



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)