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 vote337 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
2 votes325 views1 answer
Query to find table size in oracle 12c
SQL
0 vote333 views2 answers
Oracle select
SQL
0 vote406 views1 answer
Mysql get nested records
SQL
0 vote340 views3 answers
How to increase size of column in sql
SQL
0 vote328 views1 answer
Postgres read table structure
SQL
0 vote367 views1 answer
CONVERT time string into 12 hours in sql
SQL
0 vote360 views1 answer
How to change mysql root password in windows 10
SQL
8 votes301 views1 answer
Oracle find text in functions
SQL
0 vote334 views1 answer
Python list from sql
SQL