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

1 vote97 views2 answers
Mysql error 1215
SQL
0 vote103 views1 answer
Mysql trigger to delete old data
SQL
0 vote133 views1 answer
Mysql date without time
SQL
21 votes109 views4 answers
Oracle add column
SQL
1 vote151 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote107 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote99 views1 answer
Groupby sort sql hive
SQL
0 vote103 views1 answer
Sql cursor example multiple columns
SQL
0 vote106 views1 answer
How to find sql server name
SQL
1 vote57 views1 answer
Enable mysql slow query log
SQL