Order by clause for datetime stamp format

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.

(fwd) Order by clause for datetime stamp format

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

Re: Order by clause for datetime stamp format

"Peter M. Perchansky" [EMAIL PROTECTED] wrote: 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?