Thank you Sergey! I can work with that. This is great. Sincerely
Gabor On Friday, March 7, 2014 10:58:16 AM UTC-8, Sergey wrote: > > You can get this functionality by using some of the date-specific scalar > functions<https://developers.google.com/chart/interactive/docs/querylanguage#scalar_functions>that > the query language supports. Unfortunately there doesn't seem to be > anything that converts the entire time to milliseconds, but there are > various functions that can pull out the various components, such as hour() > or minute(). Here is a jsfiddle example of one such chart that uses a > spreadsheet with a timeofday type: http://jsfiddle.net/MKtv3/ > > - Sergey > > > On Fri, Mar 7, 2014 at 1:29 PM, Webservant SacFNA > <[email protected]<javascript:> > > wrote: > >> Hi All, >> I have a Google Spreadsheet with a timeofday data type column, like this: >> >> B >> >> 16:00:00 >> 18:45:00 >> 17:22:00 >> >> I am pulling the data in via a Google Visualization API query and I am >> wondering how do I construct my SELECT filter to get all rows where the >> time in column A is equal or greater than right now? >> >> Here is the relevant code segment: >> >> *var today= new Date(); var time=today.getTime(); InitQueryString="select >> * where B>="+time;* >> >> I am getting zero rows returned, but no errors. >> >> >> >> PS. f I just query on column A, it contains the day number like 0 for >> Sunday, to get me everything which is today, that works fine, so it is not >> my syntax for the actual query. >> >> This works fine: >> >> >> *var today= new Date(); var thisDay=today.getDay();* >> *InitQueryString="select * where A="+thisDay;* >> >> >> I also verified that I have the format for column B right, when I just >> pull all data, the column is of type: >> >> >> <https://lh4.googleusercontent.com/-XyFq7hiKTO8/UxoNohfnYRI/AAAAAAAAAFw/BM5GdDdkwYI/s1600/result.jpg> >> >> >> Thank you in advance, >> Sincerely, >> >> Gabor >> >> -- >> 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]<javascript:> >> . >> To post to this group, send email to >> [email protected]<javascript:> >> . >> Visit this group at >> http://groups.google.com/group/google-visualization-api. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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/d/optout.
