How to format time in influxdb select query

I am new to InfluxDB. I am querying data in admin ui. I see time as timestamp. Is it possible to see it formatted as date and time?

You can select RFC 3339 formatting by entering the following command in the CLI:

precision rfc3339

To convert influxdb timestamp to normal timestamp you can type on console:

influx -precision rfc3339

Now try with your query it should work.

For more details follow link : https://www.influxdata.com/blog/tldr-influxdb-tech-tips-august-4-2016/

Although thierry answered the question already, here is the link to the documentation as well:

precision 'rfc3339|h|m|s|ms|u|ns'

Specifies the format/precision of the timestamp: rfc3339 (YYYY-MM-DDTHH:MM:SS.nnnnnnnnnZ), h (hours), m (minutes), s (seconds), ms (milliseconds), u (microseconds), ns (nanoseconds). Precision defaults to nanoseconds.

https://docs.influxdata.com/influxdb/v1.5/tools/shell/#influx-arguments