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

1 vote245 views1 answer
Select not matching data from two tables
SQL
0 vote276 views1 answer
C# execute transact sql
SQL
23 votes285 views4 answers
Uninstall postgresql ubuntu
SQL
9 votes291 views3 answers
Find all tables with column name
SQL
5 votes271 views1 answer
Oracle list functions
SQL
0 vote263 views1 answer
Mysql Digital Ocean connection problems
SQL
1 vote286 views2 answers
Mysql limit offset
SQL
0 vote258 views1 answer
C# select Mysql
SQL
3 votes262 views2 answers
How to start mysql in terminal
SQL
11 votes263 views2 answers
Having in sql
SQL