timeinfluxdbsystemtime

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


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


Solution

  • 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