（6页PPT）不同日期单位的开始与结束日期提取.pptxVIP

5-2不同日期单位的开始与结束日期提取曾贤志教室出品

指定年的开始与结束Date.StartOfYear(dateTimeasnullabledatetime)asnullabledatetime曾贤志教室出品Date.EndOfYear(dateTimeasnullabledatetime)asnullabledatetime

指定季度的开始与结束Date.StartOfQuarter(dateTime)曾贤志教室出品Date.EndOfQuarter(dateTime)

指定月的开始与结束Date.StartOfMonth(dateTimeasnullabledatetime)asnullabledatetimeDate.EndOfMonth(dateTimeasnullabledatetime)asnullabledatetime

指定始与结束Date.StartOfWeek(dateTimeasnullabledatetime,optionalfirstDayasnullablenumber)asnullabledatetimeDate.EndOfWeek(dateTimeasnullabledatetime,optionalfirstDayasnullablenumber)asnullabledatetimeDay.Sunday 0Day.Monday 1Day.Tuesday 2Day.Wednesday 3Day.Thursday 4Day.Friday 5Day.Saturday 6

指定天的开始与结束Date.StartOfDay(dateTimeasnullabledatetime)asnullabledatetimeDate.EndOfDay(dateTimeasnullabledatetime)asnullabledatetime