I am exporting a query result from mysql to csv format. say this is my csv file X ,Y, D 0, 0, 2004 0, 1, 1984 0, 2, 1990 1, 0, 1860
when i use servlet example similar to >>> http://www.mail-archive.com/[email protected]/msg04648.html by ramya ColumnDescription cd1=new ColumnDescription("X", ValueType.NUMBER, "X"); ColumnDescription cd2=new ColumnDescription("Y" , ValueType.NUMBER, "Y"); ColumnDescription cd3=new ColumnDescription("D" , ValueType.DATE, "D" ); List<ColumnDescription> ls=new ArrayList<ColumnDescription>(); ls.add(cd1); ls.add(cd2); ls.add(cd3); dataTable = CsvDataSourceHelper.read(reader, ls, true, requestLocale); i get this result in servlet result {c:[{v:0.0},{v:2.0},{v:null}]} hence the date part is null and not understood by columnDescription Is there a way to make it understand my way of date format (only YYYY format) using any method I thinl we can to it by SimpleDateFormat class http://icu-project.org/apiref/icu4j/com/ibm/icu/text/SimpleDateFormat.html But i am not able to work it out exactly Need guidance , a bit urgent. Thanking you in advance -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
