Hi all, I have a database table which includes a timestamp(14) field.
I would like to construct an SQL statement that pulls out records between two dates, based on this field (i.e. time is not important, date is). So a user input "01/01/2001" -> "01/01/2002" and I want to retrieve all records that fall within this range, from a PHP web page. I have had a look at the timestamp page on mysql.com, but couldn't find the answer there. Any suggestions please? Cheers, Ben --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
