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 vote73 views1 answer
Psql not found windows
SQL
0 vote108 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
2 votes139 views1 answer
Install postgresql centos 5
SQL
0 vote126 views2 answers
Sql query in dax power bi
SQL
0 vote120 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote126 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote128 views1 answer
Oracle cpu metric
SQL
0 vote119 views1 answer
How to set all the min and sec data to zero in sql server
SQL
4 votes105 views4 answers
Print pl sql
SQL
0 vote135 views2 answers
Mysql update two tables at once
SQL