Changing from UTC to UTC-4 in Query

,
1

I am trying to query data from my InfluxDB database in Node-Red to fill a table. Currently the format of the time is something like 2021-05-11T13:40:35.629Z in UTC time. I simply want to make this in my timezone (4 hours behind). So in my query I tried using the code SELECT Dept,Pounds,Category,time from digfeed where time > now() - 5h tz('America/New_York') but it still spits out UTC time. I’m not sure if I am using the tz() command wrong or what, but I really would like this to be a little more human readable for whatever timezone we need.

2

Hello @paulsalibe,
Welcome!
Have you tried using the system.time() function instead of now?

3

Hi, thanks for the response! I am relatively new to Influx - just curious on how I would implement this into that query. It doesn’t seem to work the same way that now() does and if I replace now() with system.time() it spits an error.

Thanks!