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

0 vote269 views1 answer
SQL Server Enterprise
SQL
0 vote273 views1 answer
Set a value by excuting stored procedure
SQL
0 vote271 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote263 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote292 views1 answer
Sql ssrs
SQL
0 vote264 views1 answer
Oracle sql winter time change
SQL
0 vote281 views1 answer
How to know if table in rigt or left in sql
SQL
15 votes266 views4 answers
Sql update from select
SQL
15 votes486 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote296 views1 answer
Modifier une valeur sql
SQL