sql qeury BETWEEN code example

Example 1: sql between

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

Example 2: sql where time stamp is in between

WHERE  `date` BETWEEN '2013-03-26 00:00:01' AND '2013-03-26 23:59:59'