[FX.php List] Date range and MySQL

[Gjermund Gusland Thorsen]

What does between mean?

if I but in between March 5 and March 15 will it return

March 5 through March 15
or will it return
March 6 through March 14
the latter would actually be between the two mentioned dates...


2008/1/24, Tim 'Webko' Booth <tim at nicheit.com.au>:
>
> In FMP, it would look like this:
>
>  $findRec->AddDBParam('myDate', $startDate . '...' . $endDate);
>
> How would this translate to MySQL?
>
> Well, the actual SQL would look like:
> select *
> from table
> where date between [start date] and [end date]
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>