Between

[DonP]

Is MySQL's BETWEEN inclusive? For example, will this give me the whole year of will it be missing a day on either end?

$TransactionYear = date("Y")."-1-1";
$YearEnd = date("Y")."-12-31";

$DSWhere = "InvoiceDate BETWEEN '".$TransactionYear."' AND '".$YearEnd."'";

Don

http://www.pc-homepage.com/

http://www.personalzone.net/

Experienced in HTML, Perl, PHP, VBScript, PWS, IIS and Apache and MS-Access, MS-SQL, MySQL databases

 

[r937]

yes, BETWEEN is inclusive

however, BETWEEN two date values will exclude any datetimes after midnight on the last day

BETWEEN is safe to use with DATE datatype

for DATETIME datatype, you will want to use...

WHERE InvoiceDate >= '2007-01-01'
AND InvoiceDate < '2008-01-01'

r937.com | rudy.ca