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 vote196 views1 answer
Flask sqlalchemy update row
SQL
0 vote207 views1 answer
See the structure of a table mysql
SQL
1 vote211 views2 answers
Drop table if exists test
SQL
5 votes243 views1 answer
Ascending order and where in sql
SQL
1 vote199 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote249 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote217 views1 answer
Convert polygon to text in mysql
SQL
0 vote230 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote198 views2 answers
T sql null or empty string
SQL
2 votes197 views1 answer
Get first 3 letters name in sql
SQL