You can format the Dates with ICU date patterns<http://icu-project.org/apiref/icu4c/classSimpleDateFormat.html#_details>(not all patterns work, but most do). To get the day of week, use the pattern "eeee". You can also format time of day this way, eg "hh:mm a" for "08:23 PM".
There may be a way to specify these formats in the spreadsheet, but I've never tried it. You can specify them in the query using the "FORMAT" clause<https://developers.google.com/chart/interactive/docs/querylanguage#Format>, if that helps. On Friday, August 23, 2013 10:35:45 PM UTC-4, olemis wrote: > > Hi ! > > I have a GViz SQL query returning no more than 7 rows corresponding to > days of the week as returned by `dayOfWeek()` i.e. 1=Sunday, 2=Monday, > ..., 7=Saturday . I want to display labels with (day of week) names in > X (Y) axis . > > Q: > - I wonder whether is it possible to achieve this using > ICU & format clause ? > * How ? > - I'd also like to do the same for int numbers 0-23 > representing hours to make them look like > 3am, 12m , 5pm , etc ... > * Possible ? > * How ? > > TIA > > PS: If possible, I need this returned in the result set returned by > e.g. a Google Docs Spreadsheet rather than tweaked somehow using > Javascript . > > -- > Regards, > > Olemis - @olemislc > > Apache™ Bloodhound contributor > http://issues.apache.org/bloodhound > http://blood-hound.net > > Blog ES: http://simelo-es.blogspot.com/ > Blog EN: http://simelo-en.blogspot.com/ > > Featured article: > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
