Enum SqlIntervalDomain

Namespace

LinqToDB.Internal.SqlQuery

Assembly

linq2db.dll

Semantic family an interval belongs to.

public enum SqlIntervalDomain

Extension Methods

Sql.Between<T>(T, T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T?)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T?)

Sql.NotBetween<T>(T, T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

Fields

Calendar = 1

A calendar-relative interval, whose elapsed length depends on the point in time it is applied to. Corresponds to SQL INTERVAL YEAR TO MONTH and to the month component of a PostgreSQL interval.

Reserved: nothing constructs one yet. It is named here because the distinction it draws is what makes the duration family safe to reason about - an optimization that may reorder or fold a fixed duration must not do the same to a calendar one - so the two are kept apart from the start rather than after the fact.

Duration = 0

A fixed-length duration, with CLR TimeSpan semantics.

Remarks

The two families are not interchangeable and must never be mixed by an optimization. A calendar month added to a date depends on the date it is added to, and a calendar day can be 23 or 25 hours long across a daylight saving transition, while a fixed duration of one day is always exactly 24 hours.