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