<div>
$t_query = &quot;SELECT SUM(Total) AS num FROM orders WHERE date_purchased &gt;&nbsp;(CURDATE() - INTERVAL 3 HOURS)&quot;;
</div>


$t_query = "SELECT SUM(Total) AS num FROM orders WHERE date_purchased > (CURDATE() - INTERVAL 3 HOURS)";

<div>
I get an error when i test that...<br />
<br />
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOURS)' at line 1
</div>


I get an error when i test that...

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOURS)' at line 1

<div>
btw, we are using PHP Version 4.3.10
</div>


<div>
and MySQL Client API version &nbsp;4.0.16 &nbsp;
</div>


<div>
perfect. Thank you very much.
</div>


<div>
<div class="content wysiwyg-content">
How would I make this query subtract 3 hours to offset a time zone difference? Our server which holds the data is on EST but I want the data pulled from this query to be PST. Thank you.<br />
<br />
$t_query = &quot;SELECT SUM(Total) AS num FROM orders WHERE date_purchased &gt;&nbsp;CURDATE()&quot;;
</div>
</div>


How would I make this query subtract 3 hours to offset a time zone difference? Our server which holds the data is on EST but I want the data pulled from this query to be PST. Thank you.

$t_query = "SELECT SUM(Total) AS num FROM orders WHERE date_purchased > CURDATE()";

curdate time zone offset

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.