WHERE: Filtering Dates

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for speakers of other languages learning English

--Write a query to show the posts that were created this month.

SELECT * FROM dbo.Posts
WHERE CreationDate BETWEEN '2024/09/01' AND '2024/09/30';
;

edited sep 10

created sep 10

deantalbot

Options: Text-only results Include execution plan

Switch to meta site

Hold tight while we fetch your results

Results[:current/:total] Messages Graph Execution Plan

Download CSV Download XML

:records returned in :time ms:cached