Thanks, My book that I have been studying from, only show commands and no
examples. MySQL web had want I wanted at the very top.

I have finish my page now.

Chuck

on 4/6/02 11:46 PM, Georg Richter at [EMAIL PROTECTED] wrote:

> On Sunday, 7. April 2002 05:56, Chuck \"PUP\" Payne wrote:
> Hi,
>> 
>> I am trying to set up a SQL statement using NOW(), what I am wanting to do
>> is to use NOW() then do a search on any date less than 7 days. Before I get
>> several e-mails asking why. I am trying to a news base database for the
>> company intranet and I am wanting to only show newsitems that are 7 days or
>> less. And I want NOW() to set today date and then go back as far as seven
>> days. But I am not sure now to use < less than in my statement with NOW(),
>> or if it will work.
>> 
> 
> http://www.mysql.com/doc/D/a/Date_and_time_functions.html
> There is a sample how to use TO_DAYS function.
> 
> Regards
> 
> Georg
> 
> 
> ---------------------------------------------------------------------
> 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
> 


---------------------------------------------------------------------
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

Reply via email to