Incredible product!, congratulations!. i have a query that is "SELECT terminal, DATE_FORMAT(fecha, '%M') as dateyear, ..", etc. How can i get the name of the months in spanish? i tryed "SET lc_time_names = 'es_ES';SELECT terminal, DATE_FORMAT(fecha, '%M') as dateyear, .. but it doesn`t work. thank you for your support. best regards

Hi, i found out how : you have to add the function for conversion to the field you want to change the language...

            "columns"=>array(
                "dateyear"=>array(
                    "title"=>"Ventas comparativa 3 ultimos años",
                    "label"=>"dateyear",
                  "formatValue"=>function($value){
                        setlocale(LC_TIME, "es_ES");
                        return strftime("%B",strtotime($value));
                    }
                    ), ... etc

now it works perfectly