How about = instead of 'AS'
create view dbo.GlobaldataEOLT2
as
select [NUMCAM]
,[C_Fourn]
,[date_passage]
,[heure_passage]
,[banc]
,[NUMPale]
,[Module_Status]
,[Code_defaut]
,[Total_TestTime]
,[Purgerunin_TestTime]
,[ShifterPosHyst_TestTime]
,[ShifterActRespTime_TestTime]
,[GearActStroke_TestTime]
,[GearActRespTime_TestTime]
,[LeakageON_TestTime]
,[K1K2Leakage_TestTime]
,[QPVK1DeliveryTest_TestTime]
,[PPVK2PressureTest_TestTime]
,[LeakageOFF_TestTime]
,[PRVTest_TestTime]
,[OPS_NRV_Test_TestTime]
,[version_prog]
,[Jourprod] =
CASE WHEN heure_passage BETWEEN '00:00:00' and '05:59:59' THEN day(jour_passage) -2
ELSE day([date_passage]) -1
END
FROM dbo.T_EOLT_BRUTE_FLOAT
or
CASE WHEN heure_passage BETWEEN '00:00:00' and '05:59:59' THEN day(jour_passage) -2
ELSE day([date_passage]) -1
END as [Jourprod]