[SOLVED]  DATE VALUE AS YEAR no 2

This topic is locked

[SOLVED] DATE VALUE AS YEAR no 2	8/31/2011 5:54:27 AM
PHPRunner General questions
C ckapote author HI , I HAVE A DATE FIELD I.E. 19/12/2011, 10/12/2011 AND I NEED TO CREATE A REPORT AND TO SORT PER YEAR . PLS HELP

2 replies


C	cgphp 8/31/2011
	Order your query by date field. Append the order by clause to the SQL query: `ORDER BY YEAR(you_date_field_name)`


C	ckapote author 8/31/2011
	Order your query by date field. Append the order by clause to the SQL query: `ORDER BY YEAR(you_date_field_name)` Thank you Very Much!!!!

2 replies