Posted by Manuel Lemos on 05/11/05 21:44

Hello,

on 05/11/2005 03:17 AM mwestern@sola.com.au said the following:
> I have a small problem.
>
> I have a project in which someone has got three integer fields for
> holding the date. DD, MM, YYYY in an sql database. I now have to
> have a page that inputs two dates and select records between those two
> dates.
>
> If I had a date field in the table it would be fairly simple, but I'm
> hoping to do this search/comparison without having to rewrite the
> pages/database that has already been designed.
>
>
> Start Date: 11/05/2005
> End Date: 11/04/2005
> SELECT * FROM blah WHERE mm BETWEEN 04 AND 05 AND dd BETWEEN 11 AND 11
> AND yyyy BETWEEN 2005 AND 2005
>
> Doesn't work for obvious reasons. Is there any way that I can do
> this date comparison I the SQL statement without having a decent date
> field?
> My apologies as this is australian date format and this list is in the
> US I think?

The format is only relevant for outputing dates. For querying you can
use the date values directly to delimit the range that you want

SELECT * FROM blah WHERE mm BETWEEN '11/04/2005' AND '11/05/2005'


--

Regards,
Manuel Lemos

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

PHP Reviews - Reviews of PHP books and other products
http://www.phpclasses.org/reviews/

Metastorage - Data object relational mapping layer generator
http://www.meta-language.net/metastorage.html

[Back to original message]