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

7 votes297 views6 answers
Mysql group concat
SQL
0 vote249 views1 answer
Sql comparison operators
SQL
0 vote332 views1 answer
Reset a table's identity column and remove test records
SQL
2 votes292 views1 answer
Q operator in plsql
SQL
2 votes302 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote267 views1 answer
Set mysql socket file docker windows
SQL
93 votes353 views4 answers
Create database postgres
SQL
0 vote247 views1 answer
Dump only schema
SQL
0 vote269 views1 answer
Mysql query problems and solutions
SQL
0 vote298 views1 answer
T-sql update table variale
SQL