Answer the question
In order to leave comments, you need to log in
How to make select by date interval correctly?
Hello everyone!
I need to select records in my database that are in the interval of the publication date of the record for the last 7 days. The PublishDate field is responsible for this.
Here such select correct in the given plan?
SELECT * FROM Table
WHERE AND PublishDate > '20201006' AND PublishDate < '20201014'
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question