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

8 votes92 views1 answer
Oracle current date plus 1 month
SQL
2 votes135 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote179 views1 answer
Drop view sql
SQL
0 vote118 views1 answer
Hibernate xml property MySQL url, username and password
SQL
25 votes141 views6 answers
How to change column name in mysql
SQL
0 vote87 views1 answer
Sql select rows with simlar names
SQL
0 vote158 views1 answer
Eliminate zero from integer mysql
SQL
0 vote176 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
2 votes190 views1 answer
Oracle list grants on package
SQL
2 votes129 views1 answer
No data found oracle
SQL