Формат даты

[Raze669]

Добрый день, форумчане!
Помоите разобраться как установить формат даты 104 к данному подзапросу

(isnull((select isnull((select case when r.per=0 then dateadd(year,-1, GETDATE()) 
							  when r.proizv=1 and exists(select 1 
					 from _KON_KSP K 
					 WHERE K.KMAT=DMS.KMAT AND (ISNULL(K.UNDOC,0)=0 OR ISNULL(K.UNDOC,0)=dms.UNDOC )) then dateadd(year,-1, GETDATE()) 
							  ELSE 
						 CASE WHEN R.DATE_P IS NULL AND NOT R.per IS NULL THEN  dateadd(year,-4, GETDATE()) 
							  ELSE  DATEADD(DAY,R.per,R.DATE_P) 
							  END 
						 END 
			from(select min(pk.KOEF_SP1) per,isnull(MAX(pk.KOEF_SP2),0) proizv,(select convert(char(10), (MAX(k.DATE_P)), 104) 																						   from _KON_KSM k 																								   where k.KMAT=dms.KMAT AND k.GR_US= 'СКЛАД'																								   ) DATE_P 
									from _KON_KON k 
									inner join SP2 grUs 
										ON grUs.SPR='_K_OTV' AND grUs.KOD_N=k.OTV 
									inner join SP2 gU 
										ON gU.SPR='_GR_US' and gU.KOD_C=grUs.CHAR_SP6 AND gU.PARENT_C='СКЛАД' 
									INNER JOIN SP2 pK 
										on pK.SPR='_K_PKO' and pK.KOD_N=k.PKO 
									where k.ID_GR=t.K_KTHR and convert(date,k.DATE_D)<=dmz.ddm) r ),dateadd(year,1, GETDATE())) 
				from TTHR t 
				where t.KTHR='KON_GR' and t.STRKEY=dms.KMAT and convert(date,t.DATE_D)<=dmz.ddm ) ,dateadd(year,-1, GETDATE()))
		)

[Raze669]

Крутил, крутил, понял наконец-то)

convert(char(10),((isnull((select isnull((select case when r.per=0 then dateadd(year,-1, GETDATE()) 
										  when r.proizv=1 and exists(select 1 
																	 from _KON_KSP K 
																	 WHERE K.KMAT=DMS.KMAT AND (ISNULL(K.UNDOC,0)=0 OR ISNULL(K.UNDOC,0)=dms.UNDOC )) then dateadd(year,-1, GETDATE()) 
																	 ELSE 
																		CASE WHEN R.DATE_P IS NULL AND NOT R.per IS NULL THEN  dateadd(year,-4, GETDATE()) 
																			 ELSE  DATEADD(DAY,R.per,R.DATE_P) 
																		END 
									 END 
							   from(select min(pk.KOEF_SP1) per,isnull(MAX(pk.KOEF_SP2),0) proizv,(select MAX(k.DATE_P)
																								   from _KON_KSM k 
																								   where k.KMAT=dms.KMAT AND k.GR_US= 'СКЛАД'
																								   ) DATE_P 
									from _KON_KON k 
									inner join SP2 grUs 
										ON grUs.SPR='_K_OTV' AND grUs.KOD_N=k.OTV 
									inner join SP2 gU 
										ON gU.SPR='_GR_US' and gU.KOD_C=grUs.CHAR_SP6 AND gU.PARENT_C='СКЛАД' 
									INNER JOIN SP2 pK 
										on pK.SPR='_K_PKO' and pK.KOD_N=k.PKO 
									where k.ID_GR=t.K_KTHR and convert(date,k.DATE_D)<=dmz.ddm) r ),dateadd(year,1, GETDATE())
									) 
				from TTHR t 
				where t.KTHR='KON_GR' and t.STRKEY=dms.KMAT and convert(date,t.DATE_D)<=dmz.ddm ) ,dateadd(year,-1, GETDATE())
				)
		)) , 104)