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 vote161 views1 answer
Mysql column start with string
SQL
0 vote152 views1 answer
How to install mysql without admin rights
SQL
2 votes163 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote152 views1 answer
Ffeathers express mysql application users login
SQL
0 vote152 views1 answer
Android sqlite get rows count
SQL
0 vote139 views1 answer
Output table plsql
SQL
0 vote173 views1 answer
Mysql into outfile with headers
SQL
2 votes158 views2 answers
Mysql show table column comments sql
SQL
0 vote169 views1 answer
Cube oracle
SQL
1 vote232 views1 answer
Oracle datafile max size 32gb
SQL