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

10 votes321 views1 answer
Dba_dependencies
SQL
0 vote366 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote335 views6 answers
Unique key in sql
SQL
0 vote408 views1 answer
Mysql streaming example
SQL
0 vote377 views1 answer
Oracle sql all days except weekends
SQL
14 votes359 views6 answers
Auto_increment mysql
SQL
0 vote347 views1 answer
Postgresql delete multiple rows
SQL
0 vote374 views1 answer
Insert data from stored procedure into table
SQL
-1 vote391 views1 answer
Add 10 to all numbers in a column sql
SQL
9 votes373 views1 answer
No sql
SQL