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

3 votes383 views1 answer
Oracle transaction commit rollback example
SQL
0 vote375 views1 answer
Wordpress database query change url
SQL
10 votes351 views4 answers
Join with multiple conditions sql
SQL
0 vote364 views1 answer
Mysql update table from select on another table
SQL
0 vote364 views1 answer
How many rows affected in sqllite
SQL
0 vote360 views1 answer
Set a value by excuting stored procedure
SQL
0 vote352 views1 answer
How to get initials in sql
SQL
0 vote342 views1 answer
2020 new year
SQL
0 vote389 views1 answer
Mysql faster delete
SQL
0 vote370 views2 answers
Update all columns in one update
SQL