probably one of the many replys you'll get on this, but
ORDER BY month(start_date)
assuming the column that has the date is start_date
On Thursday 10 July 2003 14:51, Mike At Spy wrote:
I am trying to create an order by in a select statement that takes a
standard 'date' column in a table and
I am trying to create an order by in a select statement that takes a
standard 'date' column in a table and sorts the returned data by the month
of that date.
Off hand, I tried
ORDER BY start_date(m)
And I know that is wrong. Anyone have any suggestions?
Thanks,
-Mike
--
MySQL General
Try:
order by left(start_date,7)
That will order by year then month for a standard date column..
Cheers,
Andrew
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]
Sent: Thursday 10 July 2003 20:51
To: [EMAIL PROTECTED]
Subject: ORDER BY with Date Format
I am trying
