It seems that InfluxDB3 ignores timezone in timestamps in date_bin function when using FlightSQL.
I’m trying to use date_bin function to aggregate points in certain time windows (for instance group by day), but they work as if I’m using UTC timezone.
I have tested ordinary queries, (without any aggregation applied), and they work.
Ok, I’ve got it solved. This function splits data into bins, but it has an optional argument origin_timestamp, using which you may set point from which to calculate bins, and this solves problem. It would be nice to provide more detailed description in documentation for this case, because it is not intuitive at all.
@Oleh_Paduchak Thanks for sharing your answer with the community!