>-----Original Message-----
>From: PHPWIN
>Sent: Monday, May 07, 2001 5:06 AM
>To: [EMAIL PROTECTED]
>Subject: [PHP-WIN] Get rows over certain data
>
>
>Hi
> Anyone knows how to retrieve rows over a certain date in
>MySql if the rows all have a datetime field, of type timestamp .
>Like to get the rows modified in the last week or 3 days or just today?
select *
from timetable
where convert(varchar, date, 112) between '20010407' and '20010507'
/RTFM
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
