requete sql (date)

bonjour,

comment je peux récuperer la date d'aujourd'hui dans une requete sql sous sql server merci

SELECT Cast(Left(DateEnr,11) as DateTime) AS DateEnr FROM WeserDataBAse.dbo.QteReel where Cast(Left(DateEnr,11) as DateTime)=Datetime.now() Group by Cast(Left(DateEnr,11) as DateTime) order by Cast(Left(DateEnr,11) as DateTime) desc

Code:

---

select Getdate()

---