<div>
Wow. That was easy for you.<br />
<br />
Solution:<br />
Cut n paste is not always a time saver.
</div>


Wow. That was easy for you.

Solution:
Cut n paste is not always a time saver.

<div>
A great answer to get right to the point.<br />
Thanks.
</div>


A great answer to get right to the point.
Thanks.

<div>
<div class="content wysiwyg-content">
runTime &nbsp;is datetime type.<br />
<br />

<pre><code id="code-10-27040348-1">SELECT * FROM User WHERE runTime BETWEEN 2011-05-16 03:01:00 AND 2011-05-16 03:01:00</code></pre>
<br />
Results in:<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 '02:59:00 AND 2011-05-16 03:01:00' at line 1<br />
<br />

<pre><code id="code-10-27040348-2">SELECT * FROM User WHERE runTime BETWEEN '2011-05-16 03:01:00' AND '2011-05-16 03:01:00'</code></pre>
<br />
Results in:<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 '' at line 1<br />

</div>
</div>


runTime  is datetime type.

(CODE)

Results in:

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 '02:59:00 AND 2011-05-16 03:01:00' at line 1

(CODE)

Results in:

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 '' at line 1


Between MySQL datetime values?

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.