When you are in the `influx` CLI, you can switch the display to human-readable timestamps by issuing the command:
``` > precision rfc3339 ``` Or you can set it before logging into the instance by adding the parameter `-precision rfc3339` to the CLI option, for example: ``` influx -precision rfc3339 ``` Thanks, Ross On Tue, Jun 14, 2016 at 11:50 PM, sangkook Noh <bit4...@gmail.com> wrote: > > My Fluxdb Query Result is bellow > time column formant is nanoseconds > So I want change the time formant to human readable like next > How can I change > > [root@DBAnode01GH ~]# influx > > use test > Using database test > > select * from cpu; > name: cpu > --------- > time host region value > 1465799105917130413 serverA us_west 0.64 > > > > I hopoe > > select * from cpu; > name: cpu > --------- > time host region value > 2016-10-01 12:00:00 serverA us_west 0.64 > > -- > 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 influxdb+unsubscr...@googlegroups.com. > To post to this group, send email to influxdb@googlegroups.com. > 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/d6a56784-b636-422e-b5ca-3ddb199e1e91%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/d6a56784-b636-422e-b5ca-3ddb199e1e91%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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 influxdb+unsubscr...@googlegroups.com. To post to this group, send email to influxdb@googlegroups.com. 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/CAD8sRLC%3DaiLUpRq1LjahKqqsvuMaiadCAw6g0vMJ4ODu6Dzq9w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.