المسابقة الالكترونية

SElect *,convert(varchar(20),StartDate,103) as StartDate1,convert(varchar(20),EndDate,103) as EndDate1 from Cont_Contest WHERE (cast(getdate() as date) between cast(StartDate as date) and cast(EndDate as date) ) and Active='True' and uniqueid='b9787b5f-f163-4d85-b752-9a92bfaf8ccf' order by id desc