How Can I Use Current Date In Sql Server To Fetch Data From Db With Out Changing Date Every Day

See more:

SQL-Server

SQL-Server-2012

Hi,

How to fetch current day data from database passing query without
mentioning date in query, i mean query use server current date while fetching records from database

select  CAST(dateadd(S,Create_date+''19800'',''19700101'') as DATE) as ''Date'',   CAST(DATEPART(HOUR, dateadd(S,Create_date+''19800'',''19700101'')) as varchar)+ '':00'' as ''Hour'' , 
count(1) as Count from ARSystem.dbo.TechM_Indus_LogDeliverSMS where  char_TicketNumber__c like ''INCN%'' and dateadd(s,Create_date+''19800'',''19700101'')  >= ''11/01/2015 12:00:00 AM''and  dateadd(s,Create_date+''19800'',''19700101'')  <= ''11/01/2015 23:59:00 PM''
 group by CAST(dateadd(S,Create_date+''19800'',''19700101'') as DATE), DATEPART(HOUR,dateadd(S,Create_date+''19800'',''19700101'')) order by Hour asc