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

2 votes158 views1 answer
Grant revoke privileges to mysql username
SQL
2 votes154 views1 answer
Add new column not null sql server
SQL
0 vote135 views2 answers
Mysql two column combination unique
SQL
2 votes143 views3 answers
Current month mysql query
SQL
5 votes141 views1 answer
Oracle get nls settings
SQL
0 vote163 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote181 views1 answer
Mysql extract day from date leading zero
SQL
15 votes144 views3 answers
Mysql update add to existing value
SQL
0 vote149 views1 answer
Stratified sampling sql
SQL
0 vote143 views1 answer
How to install mysql without admin rights
SQL