----�������ڼ���sql

declare @begdate date,@enddate date
set @begdate='2023-02-02'
set @enddate='2023-12-15'

declare @begdate_MonthStart date --��ʼ���ڵ��µ�һ��
declare @begdateLY date,@enddateLY date,@begdatePM date,@enddatePM date
declare @begdate1M date,@enddate1M date,@begdate3M date,@enddate3M date,@begdate6M date,@enddate6M date

--����ͬ��(��ʼ���ںͽ�����ڵݼ�һ��)
select @begdateLY=dateadd(yy,-1,@begdate)
select @enddateLY=dateadd(yy,-1,@enddate)

--���ڻ���(��ʼ���ںͽ�����ڵݼ�һ����)
select @begdatePM=dateadd(mm,-1,@begdate)
select @enddatePM=dateadd(mm,-1,@enddate)


--ǰ1����(��ʼ������ǰ1�����)

--��ʼ���ڼ�һ���µ�һ��
select @begdate_MonthStart=dateadd(month, datediff(month, 0, @begdate), 0)
--ǰ1����(��ʼ������ǰ��1����)
select @enddate1M=dateadd(DD,-1,@begdate_MonthStart)
select @begdate1M=dateadd(month, datediff(month, 0, @enddate1M), 0)


--ǰ3����(��ʼ������ǰ�������)
select @enddate3M=@enddate1M
select @begdate3M=dateadd(MM,-2,@begdate1M)

--ǰ6����(��ʼ������ǰ��6����)
select @enddate6M=@enddate1M
select @begdate6M=dateadd(MM,-5,@begdate1M)


select 
@begdate as ��ʼ����,@enddate as �������
,@begdate_MonthStart ��ʼ���ڵ��µ�һ��
,@begdateLY as ���꿪ʼ,@enddateLY as ������
,@begdate1M as ���¿�ʼ,@enddate1M as ���½��
,@begdate3M as ǰ��¿�ʼ,@enddate3M as ǰ��½��
,@begdate6M as ǰ���¿�ʼ,@enddate6M as ǰ���½��