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 vote200 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote181 views1 answer
SQL server select to get sum of hours
SQL
0 vote198 views1 answer
Mysql remove tabs from string
SQL
0 vote206 views1 answer
Oracle DROP PROGRAM
SQL
6 votes217 views2 answers
How to copy data in sql
SQL
1 vote204 views1 answer
Mysql show table character set
SQL
2 votes235 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote209 views1 answer
Sql select most frequent value in column
SQL
0 vote240 views1 answer
Mysql streaming example
SQL
0 vote203 views1 answer
Original Query
SQL