SoftadminUtil.DatePeriod_Intervals

Show allHide all
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.