Yep, that's one of the sources which comfirm that Day/Month/Year are valid MySQL functions !
> Check this link out: > > http://www.mysql.com/doc/en/Date_and_time_functions.html > > This details all the date functions in mySQL. > > HTH, > Steve > > > -- > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Stephen Bosworth > Application Development and Integration > Communication and Information Services > The University of Newcastle, Australia > Phone: 02 4921 6574 > Fax: 02 4921 7087 > Email: [EMAIL PROTECTED] > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > >>> [EMAIL PROTECTED] 11/12/2003 2:23:24 pm >>> > > Sorry guys, I've just tried datepart as well, and get the same error > (i.e. > > invalid mysql syntax). > > Then that will be your clue then. You should check out the MySQL > documentation about what you can and can't do with Dates. > > That would be my next step - but I don't really have any spare time to do > that at the moment. > > > Gary Menzel > Web Development Manager > IT Operations Brisbane -+- ABN AMRO Morgans Limited > Level 29, 123 Eagle Street BRISBANE QLD 4000 > PH: 07 333 44 828 FX: 07 3834 0828 > > > > > If this communication is not intended for you and you are not an authorised= > recipient of this email you are prohibited by law from dealing with or = > relying on the email or any file attachments. This prohibition includes = > reading, printing, copying, re-transmitting, disseminating, storing or in = > any other way dealing or acting in reliance on the information. If you = > have received this email in error, we request you contact ABN AMRO Morgans = > Limited immediately by returning the email to [EMAIL PROTECTED] = > and destroy the original. We will refund any reasonable costs associated = > with notifying ABN AMRO Morgans. This email is confidential and may = > contain privileged client information. ABN AMRO Morgans has taken = > reasonable steps to ensure the accuracy and integrity of all its communicat= > ions, including electronic communications, but accepts no liability for = > materials transmitted. Materials may also be transmitted without the = > knowledge of ABN AMRO Morgans. ABN AMRO Morgans Limited its directors and = > employees do not accept liability for the results of any actions taken or = > not on the basis of the information in this report. ABN AMRO Morgans = > Limited and its associates hold or may hold securities in the companies/tru= > sts mentioned herein. Any recommendation is made on the basis of our = > research of the investment and may not suit the specific requirements of = > clients. Assessments of suitability to an individual?s portfolio can only = > be made after an examination of the particular client?s investments, = > financial circumstances and requirements. > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > .au=20 > To unsubscribe send a blank email to [EMAIL PROTECTED] > au=20 > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
