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 vote308 views1 answer
Oracle DROP PROGRAM
SQL
0 vote328 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote299 views1 answer
Except in sql alchemy
SQL
0 vote300 views2 answers
Drop check constraint in ms sql
SQL
0 vote299 views1 answer
Sub query in linq
SQL
0 vote316 views1 answer
Migrations.RunSQL
SQL
0 vote269 views2 answers
Influxdb delete measurement based on date
SQL
6 votes358 views3 answers
Check if string contains substring sql
SQL
0 vote302 views1 answer
Multiple tricky query in sql server
SQL
0 vote326 views2 answers
Mysql update two tables at once
SQL