Select all current date data in SQL Server

Hi indradeo,

Please check for year as well in your where condition.

SQL

SELECT nm,Vhclrgn,spd,dptangcy,vltrsdt,lcn,
CASE when Len(PhotoPath)<10 then 'images/profilepic.png' else Replace(PhotoPath,'~/','') end as PhotoPath
FROM Spd_Vltrs
WHERE month(vltrsdt)=month(getdate()) and Day(vltrsdt)=Day(getdate()) and Year(vltrsdt)=Year(getdate()) and isnull(sn_to_intrant,0)='YES'
ORDER BY Month(vltrsdt)*100+Day(vltrsdt)