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

6 votes120 views1 answer
Phpmyadmin reset root password
SQL
10 votes169 views4 answers
Sql server pagination
SQL
14 votes136 views2 answers
Oracle limit rows
SQL
0 vote124 views2 answers
Homebrew nysql launch
SQL
23 votes135 views4 answers
Sql server substring
SQL
0 vote97 views1 answer
Postgresql add leading zeros
SQL
4 votes133 views3 answers
Sqlite show columns
SQL
0 vote138 views1 answer
Modifier une valeur sql
SQL
0 vote139 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
17 votes257 views4 answers
Show all tables in oracle
SQL