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 vote175 views1 answer
Add constraint sql
SQL
0 vote175 views1 answer
Oracle grant create job
SQL
11 votes557 views4 answers
Reset identity column values in sql server
SQL
0 vote177 views1 answer
Prepared statement mysql java delete selected rows
SQL
8 votes188 views2 answers
Oracle auto increment primary key
SQL
0 vote192 views1 answer
Get last three characters in mysql column
SQL
0 vote177 views1 answer
Json not contains mysql
SQL
2 votes189 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
1 vote176 views1 answer
Create table variable in sql stored procedure
SQL
0 vote174 views1 answer
List all functions and procedures in postgres query
SQL