How to format time in influxdb select query

influxdb
PolinaC picture PolinaC · Jul 26, 2015 · Viewed 78k times · Source

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?

Answer

thierry picture thierry · Jan 4, 2016

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

precision rfc3339

Related questions

Can you delete data from influxdb?

How do you delete data from influxdb? The documentation shows it should be as simple as: delete from foo where time < now() -1h For some reason, influxdb rejects my delete statements saying "Delete queries can't have where clause …

Read More
InfluxDB - Getting only last value in query

Is possible to query only for the last value (or n-th value) of the results of a query? For example, in the query: SELECT value FROM response_times WHERE time > now() - 1h limit 1000; Is possible to get only …

Read More
In Influxdb, How to delete all measurements?

I know DROP MEASUREMENT measurement_name used to drop single measurement. How to delete all measurements at once ?

Read More