SQL SERVER中每年的数据片段的时间范围提取出来。

简介：
获取项目的时间范围 在数据库操作中，Dbo被调用以获取指定时间段内特定类型的日期信息。Date type: (preceding period indicated by -, current period with no symbol, next period marked by +). datetype: returns a specific time point if the start date is provided (S), or spans from the start to end of the interval (E). datetime: specifies which time instance should be used for calculation. time: returns an exact timestamp (e.g., 8 AM). If this timestamp falls on September 1, 2022 at 7:59:59 PM, then returning a query for August last day with start time at 8 AM will result in the end timestamp being September 1, 2022 at approximately 7:59:59 PM.该函数返回上季度开始时间为零点的结果。执行dbo.GetDateStartFirstAndLast(-q,e,2022-08-03,8)返回值为2022-07-01 07:59:59.997，在上季度结束时8点。