I have a SQL Server database table that I want to select rows from for the last seven days. I use the date field, but it appears that my query isn't working correctly, I may be missing records from today, the day I actually run the query. Here is my query
select * from tablea
where DATEFIELD > DATEADD(DAY, -7, GETDATE())
AND DATEFIELD < DATEADD(DAY, +1 GETDATE())
Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.