thanks! that works. On Wednesday, July 6, 2016 at 9:55:01 AM UTC-7, Ken Workspace wrote: > > hi all, > > When i make a query, the result always show as Long value (in > microsecond), is there a way to make it showing more readable format such > as "yyyy-mm-dd:hh:mm:ss" etc? > > > > > select first(price), last(price), min(price), max(price), sum(size) from > Stock where time >= now() - 1m and time < now() and ticker='ZTS' group by > ticker, time(1m); > name: Stock > tags: ticker=ZTS > time first last min max sum > ---- ----- ---- --- --- --- > 1467823800000000000 47.81 47.79 47.79 47.81 1933 > 1467823860000000000 47.79 47.79 47.79 47.79 300 > > > Thanks for your help! > Kenny >
-- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" 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 https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/64bc2b5a-9691-4cce-ad5a-62b3095d6ff4%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
