title: get data from mysql table as per IST zone
body: <p>I am using GoDaddy webserver of shared hosting.I have a mysql database in which there are 2 columns which contains datatype date.. I am using following sql queries. From query1 I am getting Expired records &amp; from query2 getting ongoing records. Problem is because webserver uses it's local time so as per indian time zone I am not getting accurate records. Is there any way to fix problem in query.</p>
  
  <p>Query1</p>
  
  <blockquote>
    <p>SELECT * FROM offers WHERE startDate &lt;= CURRENT_DATE AND endDate &lt;= CURRENT_DATE </p>
  </blockquote>
  
  <p>Query2</p>
  
  <blockquote>
    <p>SELECT * FROM offers WHERE startDate &lt;= CURRENT_DATE AND endDate >= CURRENT_DATE</p>
  </blockquote>