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 vote633 views1 answer
Sql field equals multiple values
SQL
15 votes255 views4 answers
Pl sql
SQL
2 votes280 views1 answer
Use cases condition in sql query laravel
SQL
0 vote254 views1 answer
Mysql into outfile with headers
SQL
0 vote299 views1 answer
Sql quary intervewi question
SQL
6 votes291 views2 answers
Sql sequence
SQL
15 votes279 views5 answers
If null mysql
SQL
0 vote261 views1 answer
Events not working db
SQL
0 vote277 views1 answer
Print hello world in plsql
SQL
3 votes276 views1 answer
How to find names includes in sql
SQL