title: Getting eastern standard time in a mysql query
body: <p>I have an sql query as following</p>
  
  <pre><code>select A.bus_id as busid, A.stop_id as source, A.arrival as atime, B.arrival as dtime from
      (SELECT * from schedules as S where S.stop_id = #{startStopId}) A
      inner join
      (SELECT * from schedules as S where S.stop_id = #{endStopId}) B
      on A.bustag = B.bustag
      where A.arrival &lt; B.arrival
      and A.arrival &gt; localtime;
  </code></pre>
  
  <p>The issue is that i am living in eastern standard time zone (new york) but this local time seems to be local time of where the server is located. I am using clou9 to host my application and  i suspect they are using aws or something else maybe. I basically want to do A.arrival > eastern standard time. </p>
  
  <p>I would appreciate suggestions. I was also wondering if it is possible to do it in this statement itself.</p>