Hello,
on 05/11/2005 03:17 AM mwestern@xxxxxxxxxxx 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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
