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

6 votes291 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
0 vote309 views1 answer
Mysql user set plugin
SQL
4 votes270 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
3 votes290 views1 answer
Pl sql escape &
SQL
31 votes278 views3 answers
Sql count(*)
SQL
1 vote308 views4 answers
Get week day from date in sql
SQL
1 vote248 views1 answer
Mysql get last insert id
SQL
0 vote303 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote276 views1 answer
Output to file mysql
SQL
0 vote299 views1 answer
Sql last 3 rows
SQL