Rudy,
Here is the query
SELECT `order_date` FROM `orders` WHERE to_days('2001-01-01') -
to_days(`order_date`) >= 365;
There are five entries in the column that fall in the year 2001; the
tutorial offers DATEPART, to_number and to_date variations (with their
various syntaxes) but all bring up errors in MySQL. 'to_days' was the only
thing I could find in the MySQL manual which seemed to deal with dates
within a time period.
And Rudy is right Howard, the quote marks don't solve it; but thanks for
the advice.
Joseph
> > to_days(2001-01-01)-to_days(order_date) <=365.
>
> joseph, what are you trying to do?
>
> if you have order dates in 2001 or later, that expression will always be
> true, simply because to_days(2001-01-01) will be less than
> to_days(order_date) and so the result will be negative and therefore
always
> less than 365
>
> > The query is executed successfully, but hte five entries it should
> > catch are not printed out. Your advice is welcome.
>
> five entries?
>
> can we see your query?
>
>
> rudy
>
>
>
>
> ____ . The WDVL Discussion List from WDVL.COM . ____
> To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
> Send Your Posts To: [EMAIL PROTECTED]
> To set a personal password send an email to [EMAIL PROTECTED] with the
words: "set WDVLTALK pw=yourpassword" in the body of the email.
> To change subscription settings to the wdvltalk digest version:
> http://wdvl.internet.com/WDVL/Forum/#sub
>
> ________________ http://www.wdvl.com _______________________
>
> You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to %%email.unsub%%
>
> To unsubscribe via postal mail, please contact us at:
> Jupitermedia Corp.
> Attn: Discussion List Management
> 475 Park Avenue South
> New York, NY 10016
>
> Please include the email address which you have been contacted with.
>
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
