Thank you for your answer. I just read the documentation and it is crystal clear.
I am using the InfluxDB v0.12.2, and I am getting a Zero timestamp: Select Max(Pmax) from Test0 *Test0* timemax1970-01-01T00:00:00Z 36608 It is time to upgrade, I hope it works in the last version 0.13. El martes, 9 de agosto de 2016, 19:50:17 (UTC+2), Sean Beckett escribió: > > Issue: > > SELECT MAX > <https://docs.influxdata.com/influxdb/v0.13/query_language/functions/#max>(value) > > FROM foo WHERE... > > That will return the maximum value AND the timestamp of the point with the > maximum value. > > On Thu, Aug 4, 2016 at 1:38 AM, Joaquin Rus Pezzi <[email protected] > <javascript:>> wrote: > >> I want to learn the *specific time when a minimum/maximum value was >> reached* in my data series in InfluxDB. >> >> This means querying the InfluxDB to get an specific "time" instead of a >> value. I couldn´t find any info about how to do this, and actually It seems >> it is no feasible. I got the impression that the time (Epoch in nanoseconds >> by default) is important metadata and not "accesible" from the query >> language iself. >> >> Is it possible to do this?, to query the time when a value was reached?. >> I can imagine this must be a very common request. >> >> -- >> 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 [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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/5f268b8c-c969-4b9e-b925-52d5b3b96236%40googlegroups.com >> >> <https://groups.google.com/d/msgid/influxdb/5f268b8c-c969-4b9e-b925-52d5b3b96236%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Sean Beckett > Director of Support and Professional Services > InfluxDB > -- 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 [email protected]. To post to this group, send email to [email protected]. 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/02f5bfd7-45c6-4800-91e9-3698d53d6fe1%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
