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

18 votes165 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote168 views1 answer
Mysql backup certain tables workbench
SQL
0 vote192 views4 answers
Restart MySQL
SQL
1 vote189 views1 answer
Name of today sql
SQL
7 votes175 views6 answers
Reset identity column in sql server
SQL
57 votes293 views6 answers
Mysql alter table add column
SQL
0 vote157 views1 answer
Multiple left join mysql
SQL
21 votes176 views1 answer
Cheatsheet for sql
SQL
2 votes181 views2 answers
Change varchar length mysql
SQL
0 vote174 views1 answer
Load utilities in sql server
SQL