Enum SqlIntervalUnit

Namespace

LinqToDB.Internal.SqlQuery

Assembly

linq2db.dll

Unit an interval operation is expressed in.

public enum SqlIntervalUnit

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

Day = 7

Days. Exactly 24 hours within Duration.

Hour = 6

Hours.

Microsecond = 2

Microseconds.

Millisecond = 3

Milliseconds.

Minute = 5

Minutes.

Month = 9

Calendar months. Valid only within Calendar.

Nanosecond = 0

Nanoseconds.

Quarter = 10

Calendar quarters. Valid only within Calendar.

Second = 4

Seconds.

Tick = 1

100-nanosecond units, matching Ticks.

Week = 8

Weeks. Exactly 7 days within Duration.

Year = 11

Calendar years. Valid only within Calendar.

Remarks

This is a unit, not a type: it says what an amount is counted in, and says nothing about whether the interval is a fixed duration or a calendar interval - that is SqlIntervalDomain. The calendar units at the end of the list are only valid within Calendar.

Members are ordered from the finest unit to the coarsest, but no arithmetic meaning is attached to the underlying values - do not compare them to decide which unit is finer.