Go4Expert - View Single Post

pradeep

Well then first sort by month and then by date, I would do it in mysql this way

Code: SQL

SELECT * FROM emp_profile ORDER BY MONTH(dob),DAY(dob);
 /* MONTH is a function which extracts the month from dob
     DAY is a function which extracts the date from dob
 */

Hope this solves your problem.

pradeep Team Leader
16Feb2007,13:14
	Well then first sort by month and then by date, I would do it in mysql this way Code: SQL SELECT * FROM emp_profile ORDER BY MONTH(dob),DAY(dob); /* MONTH is a function which extracts the month from dob DAY is a function which extracts the date from dob */ Hope this solves your problem.