Type:
Table-valued function
Table valued function that takes an interval and returns that interval grouped into time units with individual start and stop dates.
Parameters
@TimeUnit
mandatory
varchar
| Possible value | Description |
|---|---|
| day | |
| month | |
| quarter | |
| week | |
| year |
@IntervalStart
mandatory
datetime
@IntervalStop
mandatory
datetime
@LanguageId
mandatory
int
Resultsets
Resultset: TimeInterval
Table count:
Row count:
Columns
IntervalId mandatory int
Ordinal.
DescriptionShort mandatory string
Short description.
DescriptionLong mandatory string
Long description.
IntervalStart mandatory datetime
Start of interval.
IntervalStop mandatory datetime
End of interval.
StartsBeforeSpecifiedStartDate mandatory bit
If the interval starts before specified start date.
EndsAfterSpecifiedEndDate mandatory bit
If the interval ends after the specified end date.