SoftadminUtil.DatePeriod_Intervals

 Show all Hide all

Table valued function that takes an interval and returns that interval grouped into time units with individual start and stop dates.

Type: Table-valued function
Area of use: General use

Parameters:

@TimeUnit mandatory varchar
Possible value Description
day
month
quarter
week
year
@IntervalStart mandatory datetime
@IntervalStop mandatory datetime
@LanguageId mandatory int

Resultsets:

Resultset: TimeInterval

Repeat mode:
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.