DateTimeAggregate extension
Provides aggregate functions that are available on date time expressions.
- on
Methods
-
avg(
{Expression< bool>? filter}) → Expression< DateTime> -
Return the average of all non-null values in this group.
To only consider rows matching a predicate, you can set the optional
filter. Note thatfilteris only available from sqlite 3.30, released on 2019-10-04. Most devices will use an older sqlite version. -
max(
{Expression< bool>? filter}) → Expression< DateTime> - Return the maximum of all non-null values in this group.
-
min(
{Expression< bool>? filter}) → Expression< DateTime> - Return the minimum of all non-null values in this group.