MssqlTemporalOperators extension
The date and time expressions, on expressions whose SQL type is temporal.
Not on every expression, for the same reason the text predicates are not:
total.inYear(2026) would compile and then ask SQL Server to compare a
decimal against a date. A generated numeric column simply does not have
these; an untyped Col('CreatedAt') does, because untyped means nothing
here knows enough to refuse.
Methods
-
dateBucket(
{required MssqlDateBucketUnit unit, required int width, DateTime? origin, Duration? zoneOffset}) → MssqlExpression -
Available on MssqlTemporalExpression, provided by the MssqlTemporalOperators extension
This value snapped back to a fixed-width bucket:DATE_BUCKET. -
inYear(
int year, {MssqlOperator operator = MssqlOperator.eq, Duration? zoneOffset}) → MssqlCondition -
Available on MssqlTemporalExpression, provided by the MssqlTemporalOperators extension
Every row whose value falls inyear, as a half-open range. -
monthStart(
) → MssqlExpression -
Available on MssqlTemporalExpression, provided by the MssqlTemporalOperators extension
This value snapped back to the first day of its month, as adate. -
onDate(
DateTime day, {MssqlOperator operator = MssqlOperator.eq, Duration? zoneOffset}) → MssqlCondition -
Available on MssqlTemporalExpression, provided by the MssqlTemporalOperators extension
Every row whose value falls on the calendar dayday, as a half-open range. -
truncatedTo(
MssqlTemporalGrain grain) → MssqlExpression -
Available on MssqlTemporalExpression, provided by the MssqlTemporalOperators extension
This value snapped back to the start of itsgrain.