I am trying to use my query as the current day for my SQL query.
What I am trying below returns 0 records:
select * from [TEST].[dbo].LIMIT where endOfDay = GETDATE() select * from [TEST].[dbo].LIMIT where endOfDay = dateadd(dd, datediff(dd, 0, getdate()), 0) where endOfDay >= getdate() and endOfDay < getdate() + 1
An example date would be
Also if there is no given date for today's date can I get a range of dates?
Any help would be appreciated, thanks.