How to compare only date part when delivery date is today

sql-server getdate
user1777929 picture user1777929 · Mar 15, 2016 · Viewed 46k times · Source

I'm trying to create a report that gets records from a SQL Server database where the delivery date is today.

I've tried

select * from (tablename)
where delivery_date = getdate()

Although that didn't give me any errors, it didn't give me any records either.

I'm assuming it is because all dates are like: 

2016-03-15 00:00:00.000

Perhaps, I need to truncate the date to remove the time-stamp and then try?

Answer

DhruvJoshi picture DhruvJoshi · Mar 15, 2016

You can try a query like below

select * from (tablename)
where CAST(delivery_date as date) = CAST(getdate() as date)

Also if all delivery dates have time part like 00:00:00.000 for sure then 

select * from (tablename)
where delivery_date = CAST(getdate() as date)

would work as good.

Related questions

How to print GETDATE() in SQL Server with milliseconds in time?

I want to print GETDATE() in SQL Server 2008, I need the time with milliseconds (this is for debugging purpose - to find sp's execution time ) I find this Difference SELECT GETDATE() returns 2011-03-15 18:43:44.100 print GETDATE() returns Mar 15 2011 6:44PM I …

Read More
Rounding SQL DateTime to midnight

I am having a small problem with my SQL query. I'm using the GETDATE function, however, let's say I execute the script at 5PM, it will pull up records between 12/12/2011 5PM to 12/18/2011 5PM. How can I make it pull up …

Read More
Incorrect syntax near ')' calling stored procedure with GETDATE

Maybe I am having a moment of 'afternoon', but can anyone explain why I get Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ')'. When running CREATE PROC DisplayDate (@DateVar DATETIME) AS BEGIN SELECT @DateVar END GO EXEC DisplayDate GETDATE();

Read More