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 vote228 views1 answer
Create bakupd database sqlserver
SQL
0 vote340 views2 answers
Insert data into multiple tables mysql
SQL
-1 vote288 views1 answer
Default username and password for oracle 11g
SQL
0 vote275 views1 answer
VSCode SQL Server Connection error
SQL
1 vote287 views5 answers
What is in operator in sql
SQL
14 votes268 views1 answer
Excel is not a database
SQL
0 vote278 views1 answer
Mysql multiple count
SQL
0 vote301 views1 answer
See the structure of a table mysql
SQL
17 votes262 views4 answers
Set mysql Password
SQL
0 vote279 views1 answer
Sql get count without group by
SQL