Select Records Within Date Range

Posted on By David Kittell

This query include the start and end date.

SELECT
	*
FROM
	table
WHERE
	datefield BETWEEN '<start date>' AND '<end date>'
Originally Posted on April 24, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL

Related Posts

SQL DateTime Conversion

Posted on

– Microsoft SQL Server T-SQL date and datetime formats – Date time formats – mssql datetime – MSSQL getdate returns current system date and time in standard internal format SELECT convert(varchar, getdate(), 100) – mon dd yyyy hh:mmAM (or PM) – Oct 2 2008 11:01AM SELECT convert(varchar, getdate(), 101) –…

Read More

Mac OSX Terminal – Wi-Fi & Ethernet Switch

Posted on

Sometimes you need to turn off Wi-Fi and turn on Ethernet and vice-versa NOTE: Important to know what your configuration is. sudo ifconfig en6 up && sudo ifconfig en0 down sudo ifconfig en6 down && sudo ifconfig en0 up All information on this site is shared with the intention to…

Read More

Remove duplicates in a string array

Posted on

//error_reporting(E_ALL); //ini_set(‘display_errors’, 1); echo "<p>Original:<br/>".$_GET[’input’]."</p>"; $pieces = explode(",", $_GET[’input’]); $result = array_unique($pieces); echo "<p>Updated:<br/>"; foreach($result as $print) { echo "$print,"; } echo "</p>"; Originally Posted on September 1, 2015Last Updated on October 26, 2015 All information on this site is shared with the intention to help. Before any source code…

Read More