On Tue, 03 Apr 2001 15:00:31 -0400, "Peter M. Perchansky" <[EMAIL PROTECTED]> wrote: Greetings: I'm using the datetime format and the data is stored in mySQL as CCYY-MM-DD HH:MM:SS I want to use a SELECT statement where the ORDER BY clause is based on the date portion (CCYY-MM-DD). How would I write the clause to ignore the time portion? Thank you. ________________________________________________ Peter M. Perchansky, Microsoft FrontPage MVP Dynamic Net, Inc. Helping companies do business on the Net 109 East High Street PO Box 86 Womelsdorf, PA 19567 Voice: 1-610-589-2262 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web: http://www.dynamicnet.net/ http://www.wemanageservers.com/ ________________________________________________ --------------------------------------------------------------------- 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 -- Regards, Verle Harrison Battery Wholesale Distributors 40120 Industrial Park Circle Georgetown, TX 78626 512.869.6280 ph 512.863.0620 fax Batteries for your UPS http://batterywholesale.com/ [EMAIL PROTECTED] --------------------------------------------------------------------- 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