DATEDIFF is valid only in 4.1.1+ 4.1.1 came out in april 2003 -- over 2 years ago!
4.1.7 was the first production version of 4.1, released october 2004 the latest 4.1 release is 4.1.12 (may 2005) if you are on an older version of mysql than 4.1.1, it is incumbent on you to say so i shall now pose a challenge back to you you can accomplish the exact same results as the DATEDIFF function by using two instances of the TO_DAYS function, which has been around forever of course, this will require that you look it up, so i'll give you the url -- http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html it's important that you become comfortable looking stuff up on your own, because it is an essential skill in utilizing a database -- heck, i do it several times every day, it's something i've just come to accept as a necessary task to ensure success ;o) ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ 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.
