CODEWITHSUNDEEP
sqlsql-serverdatecase
Robit010
Robit010

Reputation: 63

SQL IF statement for todays date

I'm trying to create a condition for my SQL, that shows a 1 if that row reflects today's day.

case when A.EntryDate = GETDATE() then '1' else '0' end as Today

That's accepted but it doesn't show anything but zeros. I've only worked with Access SQL and this one seems to dislike Date()

I've been looking all around for answers and I cannot seem to find one.

Upvotes: 1

Views: 1819

Answers (1)

vendettamit
vendettamit

Reputation: 14677

The GetDate() method return datetime. To compare today's date you need to convert datetime to date.

case when cast(A.EntryDate as date)  = cast(getdate() as date) then 1 else 0 end

Upvotes: 2

Related Questions