title: SQL Server,query to get values between todays date and tomorrow date plus adding 14 hours to both the dates
body: <p>I have to get the values from table and display gridview of selected values between today and tomorrow date,my hosting company is 14 hours behind my time,so i have to add 14 hours to my code.I wrote the query and it is executing but doesnt give any values 
  Here is the query below</p>
  
  <pre><code>SELECT * FROM [customerdetails] 
  where date between dateadd(hh, 14, convert(datetime, convert(date, dateadd(d, 1, getdate())))) 
    and dateadd(hh, 14, convert(datetime, convert(date, getdate())))
  </code></pre>
  
  <p>Can anyone please help me out,thanks</p>