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 vote273 views1 answer
Oracle synonym procedure
SQL
0 vote273 views1 answer
Mysql find missing values
SQL
0 vote281 views1 answer
Postgresql certain first 4 characters in string
SQL
3 votes296 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote287 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote261 views1 answer
Trim sql oracle
SQL
6 votes322 views5 answers
Oracle list tablespaces
SQL
1 vote266 views6 answers
In sql
SQL
2 votes290 views6 answers
Mysql change timezone
SQL
4 votes273 views1 answer
Sql group by year
SQL