2. PHPRunner General questions
  3. [SOLVED]  DATE VALUE AS YEAR no 2
This topic is locked
[SOLVED]

 DATE VALUE AS YEAR no 2

 		8/31/2011 05:54:27
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
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!!!!