mysql select record between two timestamps code example

Example: sql where time stamp is in between

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