SQL order by month 1

[mars19301]

Would somebody please tell me the code (I assume the order by line) to sort a mmddyyyy field by month (birthdays). Thank you in advance.

Jim

 

[olded]

Jim:

I must be missing something. Isn't

"I assume the order by line) to sort a mmddyyyy field by month "

mmyddyyyy a date field defined in the database? Isn't

select date_column from some_table order by date_column

order month in ascending order?


Like i said: I'm probably missing something.


Regards,


Ed

 

[mars19301]

For a birthday list, I need all those for June (regardless of year of birth) followed by all for July etc.. I found an
old Informix scrip in an ACE report. If anybody wants it, I'll post it.

Thanks for your consideration.

 

[olded]

Jim:

If you are doing something like this (coldate is a date)

select month(coldate) from table_eds
where month(coldate) = 6 or month(coldate) = 7 order by 1

this works fine. Just a warning that this is a full table scan regardless if an index exists on coldate or not.

Regards,


Ed