Hi,
I just tried what you did, and couldn't reproduce...
Could you
a. publish the spreadsheet you've created and post its url
and
b. Explain what you mean by "visualize as an html table". There are several
ways to do this. Which example did you follow?
Regards,
VizBoy.
On Wed, Dec 24, 2008 at 4:31 AM, Andrey <[email protected]> wrote:
>
> Hi,
> I can't visualize the datetime values :(
>
> 1) I've created a google spreadsheet with 2 columns: event name and
> date (datetime format,e.g. 2008/12/12 3:23:23)
> 2) I can load it in through the query and visualize it as an html
> table, just like in the example you provided
> however the "datetime" column is emty.
> e.g.
> event1 (empty cell)
> event2 (empty cell)
>
> If I use date type instead of datetime, then the tables shows correct
> e.g.
> event1 2008/12/12
> event2 2008/10/12
>
> The only way it shows datetime values if I put zeros for the time,
> e.g. 2008/12/12 0:00:00
> Then I can see
> event1 2008/12/12 0:00:00
> event1 2008/12/12 0:00:00
>
> So I how do I make it show the datetime values correctly?
> may be data.getFormattedValue() does not support it?
>
> Thanks a lot
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
