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 vote325 views1 answer
Mysql is odd
SQL
2 votes532 views5 answers
Unique in sql server
SQL
1 vote362 views2 answers
Mysql extract number from string
SQL
0 vote348 views1 answer
SQL column name Oracle
SQL
0 vote379 views1 answer
Array aggre distinct postgres
SQL
0 vote354 views1 answer
SQL-Arten
SQL
0 vote339 views1 answer
Sql where part of string match
SQL
4 votes338 views1 answer
Group by mysql and concatenate string
SQL
0 vote325 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
4 votes312 views1 answer
To date oracle with time
SQL