How do I query InfluxDB to show me current time and date?

time influxdb systemtime
Tracy Ann Monteiro picture Tracy Ann Monteiro · Oct 7, 2016 · Viewed 7.6k times · Source

I couldn't find much documentation on this. How do I query InfluxDB to show me current database system time and date?

Answer

Jason picture Jason · Oct 10, 2016

SHOW DIAGNOSTICS will do it, if you're an admin.

If you're not an admin, you can cheat:

precision rfc3339
INSERT foo,dummy_tag="time_test" testval=0i
SELECT last(*) FROM foo

Which is a bit awkward. This might deserve a feature request on their github page: https://github.com/influxdata/influxdb/issues

Related questions

influxdb and grafana timezone mismatch

I'm trying to use curl to write datapoints into to influxdb and then display with grafana. The following successfully writes to influxdb, but the time is in UTC # curl -i -XPOST "http://localhost:8086/write?db=db_fio" --data-binary "test result=22" …

Read More
How to get the current time in Python

What is the module/method used to get the current time?

Read More
Java string to date conversion

What is the best way to convert a String in the format 'January 2, 2010' to a Date in Java? Ultimately, I want to break out the month, the day, and the year as integers so that I can use Date …

Read More