Sql query with date

How to query date in sql server

select  *
from events
where event_date between '2020-01-01' and '2020-01-31';

-- can include time by specifying in YYYY-MM-DD hh:mm:ss format:
select  *
from events
where event_date between '2020-01-01 12:00:00' and '2020-01-01 23:30:00';

Source: popsql.com

Similar codes

0 vote199 views1 answer
Postgresql if else endif
SQL
0 vote254 views1 answer
Inner join distinct
SQL
-1 vote183 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote199 views1 answer
How to get one year old query from plan cache
SQL
1 vote185 views1 answer
Truncate left characters mysql
SQL
3 votes218 views3 answers
Update con select postgresql
SQL
3 votes182 views1 answer
Select without null values sql
SQL
0 vote198 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
6 votes288 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
0 vote202 views1 answer
How to populate a table in MySQL from and existing csv file
SQL