RE: [PHP-WIN] Get rows over certain data
| From: | Svensson, B.A.T. | Date: | Mon, 07 May 2001 15:19:55 +0000 |
| Subject: | RE: [PHP-WIN] Get rows over certain data | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-7335@lists.php.net to get a copy of this message | ||
>-----Original Message-----
>From: PHPWIN
>Sent: Monday, May 07, 2001 5:06 AM
>To: php-windows@lists.php.net
>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