title: How to remove timestamp from date without converting it in varchar in sql server?
body: <p>I am comparing a "date" with current date(GETDATE()) using DATEDIFF().</p>
  
  <p>The problem i am facing is that the "date" is in dd/MM/yyyy format and the date i am getting 
  using GETDATE() includes the timestamp also.</p>
  
  <p>Please guide me how to remove the timestamp from GETDATE(),and also want to compare these two dates.</p>
  
  <p>Thanks in advance.</p>