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

(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

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. __