"> precision rfc3339" is what you want. See https://docs.influxdata.com/influxdb/v0.13/tools/shell/#influx-commands for more options.
On Wed, Jul 6, 2016 at 10:55 AM, Ken Workspace <[email protected]> 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/f9b00c96-d8ce-4fd3-920f-71fed2e3faa2%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/f9b00c96-d8ce-4fd3-920f-71fed2e3faa2%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- 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/CALGqCvO1%2BTUiAkHy7JizG6WK%3DM%3Dskf0aQgyu-bC6m_LgyZmGPQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
