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

1 vote265 views1 answer
Declare table variable
SQL
0 vote278 views1 answer
Load data infile mariadb slow
SQL
3 votes253 views2 answers
How to start mysql in terminal
SQL
1 vote254 views1 answer
Sql convert month name to number
SQL
0 vote273 views1 answer
Time data type in mysql
SQL
5 votes252 views1 answer
Postgresql functions
SQL
0 vote268 views1 answer
Close sql query vb.net
SQL
10 votes316 views4 answers
Join multiple tables in sql
SQL
0 vote251 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote276 views2 answers
Starts and end with vowel sql
SQL