There is no way to get InfluxDB to return a timestamp in anything but UTC. You can use the GROUP BY time(interval,offset) syntax to move the UTC boundaries to match other timezones.
https://docs.influxdata.com/influxdb/v1.0//query_language/data_exploration/#configured-group-by-time-boundaries For example, to make 1 day groups from midnight PDT to midnight PDT: SELECT foo FROM bar WHERE baz GROUP BY time(1d,7h) The timestamps reported will be UTC still, but the grouping intervals will be 07:00 UTC to 06:59 UTC the next day, rather than midnight to midnight UTC, as is the default. On Wed, Oct 19, 2016 at 11:50 AM, Ryan McKinley <[email protected]> wrote: > Is there a way to get results back with a time offset? > > I understand that timezones are not really supported yet... so i'm > wondering if there is a workaround > > Perhaps something like: > > SELECT field, time-7h as pdt FROM measurement LIMIT 10 > > Any suggestions? > > Thanks > ryan > > > > -- > Remember to include the version number! > --- > You received this message because you are subscribed to the Google Groups > "InfluxData" 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/000a7a30-8355-483d-b88a-6a4605df0fc8%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/000a7a30-8355-483d-b88a-6a4605df0fc8%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 version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" 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/CALGqCvOAvkVVk2A2-_sdhp%2B1qtqWheho_v6Eu-vMK0OG1tsr%3Dg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
