Ok I needed a ::timestamptz at time zone 'UTC' and a >= :)
On 17 October 2017 at 22:29, Glenn Pierce wrote:
> Hi so I have a simple table as
>
> \d sensor_values_days;
> Table "public.sensor_values_days"
> Column | Type | Modifiers
> ---
On Tue, Oct 17, 2017 at 2:29 PM, Glenn Pierce wrote:
> and I have a simple query that fails
>
This is not failure, this is a query that found zero matching records.
>
> Ie
>
> SELECT sensor_id, MAX(ts), date_trunc('day', ts), COALESCE(MAX(value),
> 'NaN')::float FROM sensor_values_days WHERE
Hi so I have a simple table as
\d sensor_values_days;
Table "public.sensor_values_days"
Column | Type | Modifiers
---+--+--
ts| timestamp with time zone | not null
value | d
