My database background has been mostly related to Oracle. These days, I am working as a freelancer with a company that heavily uses SQL Server. As a result, I miss knowing stuff out of my mind without having to search.
Today, I wanted to select from a table only those records that where created today. This table has a DateTime column that gets a default value from GetDate().
Here is how I did it:
[sourcecode language=”SQL”]
select *
from myTable
where DateDiff(DAY, MyDateColumn, GetDate()) = 0
[/sourcecode]
Is there a better way?